Connect OpenAI (ChatGPT) and Google Sheets

Treat a Google Sheet as the input and output of ChatGPT. Add a row with a product name, a customer comment or a link to an audio file, and FlowMattic sends it to OpenAI with your prompt and writes the answer back into the same row. Content teams, shop owners and researchers get AI results in the sheet they already use.

Try FlowMattic free See example workflows

6 triggers 29 actions 6 example workflows 4 ready-made templates Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in OpenAI (ChatGPT)10 actions

1. TriggerNew Spreadsheet Row

2. ActionGenerate Content

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Generate Content in OpenAI (ChatGPT) with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

OpenAI (ChatGPT) and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Write a product description for each new row

Shop owners list a product name and three features. Generate Content turns them into a description, and Update Row puts the text in the Description column for review.

New Spreadsheet RowGenerate ContentUpdate Row

Label customer feedback as positive, negative or mixed

Support and product teams paste survey answers into a sheet. Ask Chat GPT returns one word per comment, written into a Sentiment cell that a pivot table can count.

New Spreadsheet RowAsk Chat GPTUpdate Cell Data

Create an image from a prompt typed into the sheet

Marketers plan a batch of social visuals as rows of prompts. Each prompt goes to Generate Image, and the image link is saved beside it to open later.

New Spreadsheet RowGenerate ImageUpdate Row

Transcribe audio files listed in a sheet

Podcasters and researchers paste a link to each recording. Create Transcription turns the audio into text, which lands in the Transcript column for editing or quoting.

New Spreadsheet RowCreate TranscriptionUpdate Row

Fill a whole column overnight from existing rows

A sheet that already has hundreds of rows needs no copying. A nightly Schedule reads the range, loops over each row with Iterator and fills the empty column.

ScheduleGet Row DataIteratorGenerate ContentUpdate Row

Write social captions when a row is approved

Editors change a Status column to Approved, a Filter checks that value, and OpenAI writes captions for the approved article only, so no work is spent on drafts.

Update Specific Column ValueFilterGenerate ContentUpdate Cell Data

Set up: product descriptions from new rows

When you are done, every product you add to the sheet gets a written description in its own row.

Set up the columns
Give the sheet a header row with Product, Features and an empty Description column.
Connect both apps
In Connects, add Google Sheets with an account that can edit the file, and OpenAI (ChatGPT) with your API key.
Trigger on new rows
Create a workflow with New Spreadsheet Row, pick the spreadsheet and tab, and add a test row so the columns are captured.
Prompt OpenAI
Add Generate Content with a prompt that inserts the Product and Features cells and asks for a description of about 80 words.
Write it back
Add Update Row for the same row, map the answer to Description, test the workflow and switch it on.

From Google Sheets	To Google Sheets
Product	Prompt: product name
Features	Prompt: key features
Row ID	Update Row: row to change
Generated text	Description

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

OpenAI (ChatGPT) has no triggers, so every workflow starts from a Google Sheets trigger, a Schedule or a Webhook.
Writing back to the same sheet with New Or Updated Spreadsheet Row as the trigger can start the workflow again. Use New Spreadsheet Row or a Filter on an empty column to avoid loops.
When a filter, pivot table or later step reads the answer, ask for a fixed format, such as one word from a list you give.
Generate Image returns a link to the picture, not the picture inside the cell. Use the IMAGE formula in a nearby column if you want a preview.

OpenAI (ChatGPT)

Integration page

Actions (10)

Generate ContentGenerate content based on the prompt provided
Generate ImageGenerate image based on the prompt provided
Ask Chat GPTAsk anything to Chat GPT ;)
Generate Text to SpeechGenerates audio from the input text
Create TranscriptionTranscribes audio into the input language
Create TranslationTranslate the given audio to english
Create ModerationClassifies if text violates OpenAI's Content Policy
Analyze ImageAsks a vision model a question about an image given by URL
Create Voice ConsentRecords permission to clone a voice from a consent recording, the first step of a custom voice
Create VoiceCreates a custom voice from an audio sample and a consent id, usable in Generate Text to Speech

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

OpenAI (ChatGPT) and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Run as many rows as you like

FlowMattic has no task count, so a sheet of two thousand products costs only your OpenAI usage.

Data goes from your server to OpenAI

Rows are read by your own WordPress site and sent to OpenAI with your API key, with no third automation service storing them.

Prompts are easy to change

Edit the prompt in one step and the next row uses it. Keep a test tab to try a new prompt before it touches the main sheet.

Common questions

Can ChatGPT read and write my Google Sheet?

Through FlowMattic, yes. A Google Sheets trigger or Get Row Data reads the cells, an OpenAI action such as Generate Content or Ask Chat GPT produces the answer, and Update Row or Update Cell Data writes it back.

Will it process rows I already have?

New Spreadsheet Row only fires for rows added after the workflow is on. For existing rows, use a Schedule with Get Row Data and Iterator to work through a range, then switch that workflow off when the column is full.

Can I use different prompts for different rows?

Yes. Put a Type column in the sheet and add a Router after the trigger. Each path has its own Generate Content step, for example one prompt for blog titles and another for product copy.

Can it translate a column into another language?

Use Generate Content with a prompt that asks for the translation and write the result to a new column. Create Translation is for audio files and turns speech into English text.

Did not find your answer? You can browse the help center or ask us directly.

Start automating OpenAI (ChatGPT) and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. OpenAI (ChatGPT) integration 2.3.0, Google Sheets integration 2.2.4.