Insert and Read Data from Google Sheets

This workflow serves as a companion example for n8n's Google Sheets node documentation. It starts with a manual trigger, sets sample data (an ID number and 'n8n' name), appends it to a specified Google Sheet in range A:B, and then reads the data back from the same sheet. This demonstrates basic insert (append) and read operations using OAuth2 authentication.

Benefits include quick setup for testing Google Sheets connectivity, understanding data flow between nodes, and serving as a foundation for more complex automations like logging events or generating reports. It's lightweight with only 4 nodes, making it beginner-friendly while showcasing practical integration.

Use cases: Educational demos for n8n users, prototyping spreadsheet automations in finance reporting (e.g., appending transaction logs and retrieving summaries), productivity tasks like tracking tasks or expenses, and as a template for custom data syncing between apps and Sheets.