Business tools

Google Sheets
integration

Turn Google Sheets data into an app with tables, forms, and controlled update actions.

Start building Read the setup guide

Configure your connection, create queries, and build the interface your team needs. Try a sample prompt

Connector capabilities

What can ToolJet do with Google Sheets?

Create queries for the operations your app needs, then connect their inputs and results to the interface.

Read spreadsheet data
Append and update rows
Delete rows
Create spreadsheets

Operations and configuration can vary by connector version. Check the full Google Sheets guide.

An app you could build

Applicant tracking workspace

Read applications from a spreadsheet, filter the list, and update the selected row after a recruiter reviews it.

Try this prompt

I have a Google Sheet called Applications with name, role, reviewer, and status columns. Build an applicant tracking app with role and status filters. Let a recruiter open a row and save changes to the reviewer and status fields.

Start with this prompt in ToolJet. Sign in or create an account, then connect your data source and replace the example names and fields with yours.

Review the generated app, configure permissions, and test its queries before sharing it with your team.

Explore app templates

Connect Google Sheets

Start with the connection.

Before you begin

An authorized Google account or a supported service account connection with access to the target spreadsheet. Self-hosted OAuth setup requires additional configuration.

Add the data source
Open Data Sources in your ToolJet workspace. Select Google Sheets and enter the required connection details.
Configure and test a query
Choose an operation and supply its inputs. Start with a read operation where available; test writes with non-production data.
Build the interface
Bind query results to components and connect actions to app events. Verify permissions and error handling before rollout.

Google Sheets setup guide

Before production

Spreadsheet access and OAuth scopes determine which files the connection can use. Design around Google API quotas and changing sheet structures.

Review plans and deployment options

Frequently asked questions

What can I do with the Google Sheets integration?

Turn Google Sheets data into an app with tables, forms, and controlled update actions. Supported capabilities: Read spreadsheet data; Append and update rows; Delete rows; Create spreadsheets.

What do I need to connect Google Sheets to ToolJet?

An authorized Google account or a supported service account connection with access to the target spreadsheet. Self-hosted OAuth setup requires additional configuration.

What should I check before using Google Sheets in production?

Spreadsheet access and OAuth scopes determine which files the connection can use. Design around Google API quotas and changing sheet structures.

Can I automate tasks with Google Sheets?

Connect Google Sheets queries to app events such as button clicks and form submissions. ToolJet Workflows and Agent Builder can orchestrate supported connectors on Self-hosted deployments; those products are not available on ToolJet Cloud. Check the connector and deployment requirements for your use case.

Keep exploring

Related integrations

Browse all integrations

Authorize.net Azure repos

Put Google Sheets to work
in your next internal app.

Connect your data, build an interface, and give your team a focused workspace.

Start building Book a demo

Connector information reviewed 2026-09-25. Source: ToolJet documentation.