Back to Integrations
integrationGoogle Sheets node
integrationGraphQL node

Google Sheets and GraphQL integration

n8n lets you integrate Google Sheets with GraphQL to build powerful workflows. Design automation that extracts, transforms and loads data between your apps and services. You can choose from thousands of ready-made apps or use our universal HTTP connector to sync apps not yet in our library.

Integrate Google Sheets and GraphQL

Build your own Google Sheets and GraphQL integration

Create custom Google Sheets and GraphQL 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.

How to connect Google Sheets and GraphQL

  • Step 1: Add the first step

  • Step 2: Add Google Sheets and GraphQL nodes

  • Step 3: Connect Google Sheets and GraphQL

  • Step 4: Run workflow

Write all Linear tickets to Google Sheets

Use Case

Track all Linear tickets in Google sheets. Useful if you want to do some custom analysis but don't want to pay for Linear's Plus features (Linear Insights) or that it does not cover.

Screenshot 20240229 at 12.20.05.png

Setup

  1. Add Linear API header key
  2. Add Google sheets creds
  3. Update which teams to get tickets from in Graphql Nodes
  4. Update which Google Sheets page to write all the tickets to
    You only need to add one column, id, in the sheet. Google Sheets node in automatic mapping mode will handle adding the rest of the columns.
  5. Set any custom data on each ticket
  6. Activate workflow πŸš€

How to adjust this template

Set any custom fields you want to get out of this, that you can quickly do in n8n.

Nodes used in this workflow

Over 3000 companies switch to n8n every single week

Google Sheets supported actions

Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet

Looking to integrate Google Sheets and GraphQL in your company?

Why use n8n to integrate Google Sheets with GraphQL

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon