---
title: "GenAI for Google Workspace: Exploring Gemini API Function Calling with Google Apps Script — Part 3"
author: "Martin Hawksey"
date: 2024-01-08T21:52:15+00:00
canonical_url: https://pulse.appsscript.info/p/2024/01/genai-for-google-workspace-exploring-gemini-api-function-calling-with-google-apps-script-part-3/
markdown_url: https://pulse.appsscript.info/p/2024/01/genai-for-google-workspace-exploring-gemini-api-function-calling-with-google-apps-script-part-3.md
categories:
  - "AI"
  - "Gmail"
  - "Library"
  - "Sheets"
  - "Solutions"
tags:
  - "cts-technologies"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2024/01/gemini-pro.gif
description: "Google latest generative AI solution, Gemini, includes the capability to declare functions that the LLM can use in it's response. The response includes the name of the function and the parameters the script needs to run the function. The function isn't executed by the LLM, but run with your code, which creates really interesting opportunities for Google Apps Script solutions. In particular, given user identity and authorisation is an integral part of Apps Script and how it integrates with other Google services it means solutions like personalised mail merges can be created in a couple of lines of code. In this post I share GeminiApp a new Apps Script library for integrating with Gemini Pro and it's function calling capabilities.  "
---

# GenAI for Google Workspace: Exploring Gemini API Function Calling with Google Apps Script — Part 3

![GenAI for Google Workspace: Exploring Gemini API Function Calling with Google Apps Script — Part 3](https://pulse.appsscript.info/files/2024/01/gemini-pro.gif)

 

> Using Google Gemini API with Google Sheets to create personalized mail merges. An exploration in generative AI ‘function calling’

Google latest generative AI solution, Gemini, includes the capability to declare functions that the LLM can use in it’s response. The response includes the name of the function and the parameters the script needs to run the function.

The function isn’t executed by the LLM, but run with your code, which creates really interesting opportunities for Google Apps Script solutions. In particular, given user identity and authorisation is an integral part of Apps Script and how it integrates with other Google services it means solutions like personalised mail merges can be created in a couple of lines of code.

Follow the source link to find out more about function calling and exploring Gemini’s capabilities with data in Google Sheets.

Source: *[GenAI for Google Workspace: Exploring Gemini API Function Calling with Google Apps Script — Part 3*](https://medium.com/cts-technologies/genai-for-google-workspace-exploring-gemini-api-function-calling-with-google-apps-script-part-3-028785dafe3b)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2024/01/genai-for-google-workspace-exploring-gemini-api-function-calling-with-google-apps-script-part-3/](https://pulse.appsscript.info/p/2024/01/genai-for-google-workspace-exploring-gemini-api-function-calling-with-google-apps-script-part-3/)*