Connect Google Sheets with Gemini 1.0 Pro API for pSEO

Bring the power of Google’s powerful Gemini 1.0 Pro models to your Google Sheets that you can use for enriching your programmatic SEO datasets.

Connect OpenAI API with Google Sheets


What can I use the script for?

From generating simple product descriptions to creating different blog posts section, the simple Google Sheets Apps Script can help you do many things.

Below are some examples:


pSEO content

Can help you generate bulk content for your programmatic SEO projects right inside Google Sheets. There is absolutely no restriction on the number of rows of content you can create.


Product descriptions

Run an eCommerce website? You can use this script to generate product descriptions for 100s and even 1000s of products based on the available data points.


Personalized emails

You can generate personalized emails for hundreds of recipients based on their interests and other information. You can save a lot of your valuable time.


Similar patterns

Basically, you’re able to create content for anything that follows a pattern. Just write the prompt in a column and get the output from OpenAI in another column.

🎉 To start using, make a copy of the provided Google Sheets (you’ll get after purchasing), copy-paste the provided script, get the Gemini 1.0 Pro API, fill in the required fields in the Sheets, and just hit Run.

After purchasing the script, you will receive a Notion document with detailed instructions on how to set up and use it.


Small price, huge value

It’s not a subscription, you only pay once and use the script for multiple projects forever.


one time


The script along with the Google Sheets and detailed usage instructions.

Runs in the background ✨

Handles multiple columns & rows

Comes with detailed instructions

BYOA (Bring Your Own API)


one time


We set up the script and the Google Sheets as per your requirements.

Order through Gumroad

Questions? Please don’t hesitate to reach out to us at [email protected]


What users say

Here’s what users have to say about how powerful the script can be.

Google Sheets + OpenAI API Script - Testimonial 1
Google Sheets + OpenAI API Script - Testimonial 2


Some frequently asked questions to help you out.

1. Does it handle multiple columns of prompt and output?

Yes, the script can handle multiple columns of prompts and outputs in the same Google Sheets. You can specify multiple prompt columns and their respective output columns, separated by commas, in the “Settings” sheet.

2. Does the script work with the free Google account?

Yes, the script works well with the free Google account as well. However, the free Gmail account times out after 6 minutes, but the paid Google Workspace account go up to 30 minutes.

3. Do I need to keep my Google Sheets open?

No, you don’t need to keep your Google Sheets file open. You can just set a trigger on regular intervals, and it keeps running in the background. You will learn more about this after buying the script.

4. Can I get a refund after purchasing the script?

No, due to its digital nature, you will not get any refunds after purchasing the product.