---
title: "Let Bard answer your questions in Google Sheets with the PaLM API and Google Apps Script"
author: "Aryan Irani"
date: 2023-08-14T18:56:43+00:00
canonical_url: https://pulse.appsscript.info/p/2023/08/let-bard-answer-your-questions-in-google-sheets-with-the-palm-api-and-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/08/let-bard-answer-your-questions-in-google-sheets-with-the-palm-api-and-google-apps-script.md
categories:
  - "AI"
  - "Intermediate"
  - "Solutions"
tags:
  - "@aryanirani123"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2023/08/ezgif.com-webp-to-png-1.png
description: "In this latest Pulse post from Aryan Irani you can learn how to integrate Google Bard responses inside of Google Sheets using the PaLM API and a little bit of Google Apps Script. Using Google's MakerSuite it is easy to create an API key which you can use with a custom function in Google Sheets. Whilst the solution focuses on creating a custom function which would automatically refresh, using it programmatically to store responses could be a quick way to collaboratively experimenting with LLM text prompts."
---

# Let Bard answer your questions in Google Sheets with the PaLM API and Google Apps Script

![Let Bard answer your questions in Google Sheets with the PaLM API and Google Apps Script](https://pulse.appsscript.info/files/2023/08/ezgif.com-webp-to-png-1.png)

 

> Discover the magic of combining Palm API’s extraordinary capabilities with the limitless potential of Google Apps Script. In this blog we will be taking a look at how we use the PaLM API and Google Apps Script inside of a Google Sheet. We will be passing prompts from a Google Sheet and getting back a response. 

Learn how to integrate Google Bard responses inside of Google Sheets using the PaLM API and a little bit of Google Apps Script. Using Google’s MakerSuite it is easy to create an API key which you can use with a custom function in Google Sheets. Whilst the solution focuses on creating a custom function which would automatically refresh, using it programmatically to store responses could be a quick way to collaboratively experimenting with LLM text prompts.

Source: [Let Bard Answer Your Questions from Google Sheets with the PaLM API and Google Apps Script**](https://aryanirani123.medium.com/let-bard-answer-your-questions-from-google-sheets-with-the-palm-api-and-google-apps-script-3867e4680c0f)

---

*Published by [Aryan Irani](https://pulse.appsscript.info/p/author/aryanirani/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/08/let-bard-answer-your-questions-in-google-sheets-with-the-palm-api-and-google-apps-script/](https://pulse.appsscript.info/p/2023/08/let-bard-answer-your-questions-in-google-sheets-with-the-palm-api-and-google-apps-script/)*