Back to integrations

Google Sheets and Grist integration

Save yourself the work of writing custom integrations for Google Sheets and Grist and use n8n instead. Build adaptable and scalable Data & Storage, Productivity, workflows that work with your technology stack. All within a building experience you will love.
Google Sheets
Grist

How to connect Google Sheets and Grist

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google Sheets and Grist integration: Create a new workflow and add the first step

Build your own Google Sheets and Grist integration

Create custom Google Sheets and Grist workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google Sheets supported actions

Grist supported actions

Create Row

Create rows in a table

Delete Row

Delete rows from a table

Get Many Rows

Read rows from a table

Update Row

Update rows in a table

Other integrations with Google Sheets

Google SheetsTelegramGoogle SheetsMySQLGoogle SheetsSlackGoogle SheetsPostgres

Other integrations with Grist

GristTelegramGristDiscordGristGoogle Calendar
FAQs

FAQ

Can Google Sheets connect with Grist?

Can I use Google Sheets’s API with n8n?

Can I use Grist’s API with n8n?

Is n8n secure for integrating Google Sheets and Grist?

How to get started with Google Sheets and Grist integration in n8n.io?

Need help setting up your Google Sheets and Grist integration?

Discover our latest community's recommendations and join the discussions about Google Sheets and Grist integration.

Google Sheets Action is not picking up a list of available Sheets despite seeing the document itself

Sergey Komardenkov

Describe the problem/error/question I am testing a workflow where the final action is addition of a row into a Google sheet. I have created a new sheet, I gave it Edit permissions by link just in case, and of course I ad…

Open topic

The prompt is not being executed

sérgio eduardo floresta filho

Hello! My goal is to use Google Forms to collect information from my clients and then use n8n to automate the processing of this information. My workflow involves: Collecting data through Google Forms. Using n8n to re…

Open topic

Sending timestamp to Google Sheets with correct timezone

Julian

I’m trying to send a timestamp to a Google Sheet. Therefore, I use the expression $now.format(“HH:mm”).toString(). In n8n, the timestamp looks correct (see screenshot). However, in Google Sheets, the string value is …

Open topic

Filtering rows in google sheets with empty value in specific colum

therealJMT

Describe the problem/error/question edit: I guess I figured it out. The “isEmpty()” is a boolean function and has no output it just checks in the node if it’s true or not. For my workflow I got it running with a setup th…

Open topic

Error 400 | Google | n8n inserting too many characters in OAuth Redirect URL

Guilherme

Hello everyone, I’m having a problem logging into my Google account when I’m creating a credential for Google Sheets. :warning:Error 400: redirect_uri_mismatch I noticed that n8n is inserting an extra character in t…

Open topic

Looking to integrate Google Sheets and Grist in your company?

The world's most popular workflow automation platform for technical teams including

Why use n8n to integrate Google Sheets with Grist

Build complex workflows, really fast