Zapier → n8n · Apps
Google Sheets: from Zapier to n8n
Zapier keeps spreadsheet columns by letter (COL$A, COL$B…), not by header. The converter writes rows through the Google Sheets API with the same letters, so values land in the same columns.
n8n node: Google Sheets · Credential to connect: Google Sheets OAuth2
Actions
| Zapier action | In n8n | What carries over |
|---|---|---|
| Create Spreadsheet Row | HTTP Request → Sheets API append | Same sheet, same columns by letter, values as the user typed them. |
| Update Spreadsheet Row | HTTP Request → Sheets API update | Same row number; columns the Zap left empty keep their value. |
| Lookup Spreadsheet Row | Google Sheets → Get Row(s) | Added as a Google Sheets node with the Zap's settings in its notes; set the lookup column. |
Triggers
New Spreadsheet Row and New or Updated Row: use the n8n Google Sheets Trigger on the same sheet.
Check after converting
- Check the sheet name: the API call targets the worksheet the Zap used.
- You can swap the API call for the Google Sheets node once your headers are set.
Other apps: Gmail · Slack · ChatGPT, OpenAI and AI by Zapier · Airtable