Transform data in Google Sheets
n8n template #694Summary
Use templateThis workflow appends, lookup, updates, and reads data from a Google Sheet spreadsheet. Set node: The Set node is used to generate data that we want to add to Google Sheets. Depending on your use-case you might have data coming from a different source. For example, you might be fetching data from a WebHook call. Add the node that will fetch the data that you want to add to the Google Sheet. Use can then use the Set node to set the data that you want to add to the Google Sheets. Google Sheets node: This node will add the data from the Set node in a new row to the Google Sheet. You will have to enter the Spreadsheet ID and the Range to specify which sheet you want to add the data to. Google Sh
Hand off to your agent
Prompt
Help me set up the n8n workflow "Transform data in Google Sheets" (https://n8n.io/workflows/694). It uses: Google Sheets. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram215K
- Fully Automated AI Video Generation & Multi-Platform Publishing191K
- Generate AI Videos with Google Veo3, Save to Google Drive and Upload to YouTube156K
- Scrape business emails from Google Maps without the use of any third party APIs150K
- Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel99K
- AI-Powered Short-Form Video Generator with OpenAI, Flux, Kling, and ElevenLabs93K
- Clone Viral TikToks with AI Avatars & Auto-Post to 9 Platforms using Perplexity & Blotato84K
- Generate Leads with Google Maps82K