An easier way to connect Google Sheets with the OpenAI API without third-party tools like Zapier or Make. This “script” allows instant access to text, as well as image, outputs from different GPT and DALL-E models.
No third-party tools, no subscription, and accessible even with a free Gmail account. And the best thing is, the script keeps running in the background without having to keep your Google Sheets open.
🎉 starts from $20 (one time)
What can I do with the “script”?
You can bring the power of OpenAI language models like GPT-4 & GPT-3.5, and image models like DALL·E 3 to your Google Sheets file and utilize them to create text as well as text content for 1000s of rows at once.
For example:
- Generate product descriptions based on several data points
- Create personalized emails for 1000s of guests based on available data
- Do programmatic SEO by creating super-optimized AI content
- Generate content for anything and everything that follows a pattern
- Generate featured images (OG images) for 1000s of blog posts
- Create bulk images for large programmatic SEO projects
Here’s a quick video that shows how powerful this simple script can be:
How to use the “script” inside Google Sheets
As shown in the above video, here are the steps to get the script working:
- Make a copy of the provided Google Sheets file
- Get the OpenAI API from their official website
- Fill up all the required fields in the “Settings” sheet
- Select the appropriate models
- Fill in all required information
- Navigate to
Extensions > Apps Script - Select the
generateTextorgenerateImagesfunctions in the script, and - Hit the Run button
And within moments, you will start getting outputs (text and/or images) from the OpenAI API right inside your Google Sheets.
If this all seems complicated, don’t worry! After you purchase the “script” from Gumroad, you will get a Notion document with even detailed instructions to get everything working.
Generate Text
🎉 $20 (one-time)
- Generates text only
- Uses models like GPT-4 and GPT-3.5
- Handles multiple columns and rows
- Keeps running in the background
Generate Text + Images
🎉 $39 (one-time)
- Generates text as well as images
- Use models DALL·E 3 and DALL·E 2
- Handles multiple columns and rows
- Keeps running in the background
What people say
This looks great! I’m going over to PH to upvote this.
Been using a basic one for a while but this seems to be even better.
Congratulations for the launch! This looks really interesting.
Looks really promising. Kudos to the creator for making an amazing product. 👍
Also, you can directly look at these responses from people on Twitter and Product Hunt.
FAQs
1. Does it handle multiple columns of prompt and output?
Yes, the script handles multiple columns of prompts and then gets you the output in their respective specified columns.
Here’s how to do that…
You can specify multiple prompt and their respective output columns separated by commas in the “Settings” sheet; there is absolutely no limit here.
2. Do I need any subscription for this to work?
No, you don’t need any subscriptions for this. The script works well, even with the free Google account.
3. What are the limitations of the “script”?
The free “gmail.com” accounts get timed out in 6 minutes, and paid Google Workspace accounts get timed out in 30 minutes. But you can set triggers so that the script automatically keeps getting triggered and running in the background.
4. Does the script work with the free Google account?
Yes, the script works well with the free Google account, but you will get timed out in 6 minutes. And as you upgrade to the paid Workspace account, the same script will keep running for 30 minutes in one go.
5. Do I have to keep my Google Sheets open to get the output?
No, a trigger can be set so that the script continues to run at regular intervals without you having to open the Google Sheets file and click anything. You will learn more about this after buying the script.
6. Do I need the OpenAI API for this?
Yes, this is a BYOA (bring your own API) product, so you will need your own OpenAI API to work with it. You can get the API from here.
7. Does the ChatGPT Plus work with this?
No, even if you’re subscribed to ChatGPT Plus, you still need the OpenAI API to generate text or images. To help, GPT-4 only costs you ~$8 to generate 100k words, and DALL-3 costs you only $4–12 to generate 100 images.
8. How many images can I store in Cloudinary?
Cloudinary gives you ~25 GB of storage in the free account, so even if each image is of 500 KB in filesize, you would be able to store over 50,000 images. However, you also have the option to sign up for a paid Cloudinary account.
9. Can I get a refund for the script?
No, due to its digital nature, you will not get any refunds after purchasing the product.