Google Sheets Automation Workflows
3,636 ready-made Google Sheets workflows for n8n, Make, Zapier, Activepieces, and Pipedream. Spreadsheet-driven automations: logging, reporting, syncing rows to and from every tool in your stack.
Automate Data Collection and Email Notifications with n8n, Google Sheets, and Airtable
Efficiently collect user data via an n8n form, process it, store it in Google Sheets and Airtable, and send personalized email notifications.
n8n$9.99Create Front contacts from Google Sheets rows and add them to groups
Every time a new row is added in a Google Sheet, Make will automatically create a new contact in Front and send a message to that contact using Front. This example uses the sheet in [this link](https://docs.google.com/spreadsheets/d/1I_0ORbuaKUyehO5qj7l3iWRNYELfAuG5lQzLfyuSw9A/edit#gid=0).
Make$3.99Analyze BeyondPresence Video Calls with GPT-4o-mini and Google Sheets
Transform your [BeyondPresence](https://app.bey.chat/settings) video agent conversations into comprehensive insights by automatically analyzing each call with AI and organizing 35+ data points in Google Sheets. This template helps customer success, support, and training teams save 30+ minutes per call on documentation while ensuring no critical action items or insights are missed. ## How it works - **Webhook receives** completed call data from BeyondPresence including full transcript - **Data validation** ensures quality and adds enriched metadata (duration, time calculations) - **AI analysis** (GPT-4) extracts action items, sentiment, decisions, and recommendations - **Parse response** handles the AI output and structures it for sheets - **Auto-append** to Google Sheets with 35+ insights per call organized beautifully ## Set up steps 1. **Copy our Google Sheets template** - One click! Get pre-formatted sheet: [BeyondPresence Call Analytics Template](https://docs.google.com/spreadsheets/d/1O6-jkCtoSFNLJObtN0UyklgdUd3ZxEnUaNvUaBjpvo/copy) 2. **Connect accounts** - Add OpenAI API key and Google Sheets OAuth2 3. **Configure webhook** - Copy URL from n8n to [BeyondPresence Settings](https://app.bey.chat/settings) → Webhooks 4. **Customize AI prompt** (optional) - Adjust analysis focus for your use case 5. **Test with a call** - Make a test call and watch insights appear! **Setup time**: 5-10 minutes **Requirements**: BeyondPresence account, OpenAI API key, Google account
n8n$9.99Trigger new articles from RSS feeds and add them to Google Sheets
Automatically track new articles from RSS feeds and log them into Google Sheets for easy access and organization of your content updates.
MakeFreeFetch range values from Google Sheets and update a cell from ChatGPT responses
This template fetched range values from Google Sheets, generate responses using ChatGPT, and update a cell with new insights for streamlined data management.
Make$3.99Send a ChatGPT Email Reply and Save Responses to Google Sheets
This workflow sends an OpenAI GP reply when an email is received from specific email recipients. It then saves the initial email and the GP response to an automatically generated Google spreadsheet. Subsequent GP responses will be added to the same spreadsheet. Additionally, when feedback is given for any of the GP responses, it will be recorded to the spreadsheet, which can then be used later to fine-tune the GP model. ## Prerequisites - [OpenAI credentials](https://docs.n8n.io/integrations/builtin/credentials/openai/) - [Google credentials](https://docs.n8n.io/integrations/builtin/credentials/google/) ## How it works This workflow is essentially a two-in-one workflow. It triggers off from two different nodes and has very different functionality from each trigger. The flow triggered from the `On email received` node is as follows: 1. Triggers off on the `On email received` node. 2. Extract the email body from the email. 3. Generate a response from the email body using the `OpenAI` node. 4. Reply to the email sender using the `Send reply to recipient` node. A feedback link is also included in the email body which will trigger the `On feedback given` node. This is used to fine-tune the GP model. 5. Save the email body and OpenAI response to a Google Sheet. If a sheet does not exist, it will be created. The flow triggered from the `On feedback given` node is as follows: 1. Triggers off when a feedback link is clicked in the emailed GP response. 2. The feedback, either positive or negative, for that specific GP response is then recorded to the Google Sheet.
n8n$24.99Automated Supplier Email Assistant with OpenAI & Google Sheets
Automates searching suppliers in Google Sheets, drafting professional emails via OpenAI, and sending them through Gmail based on simple user requests.
n8n$14.99Send parsed JSON data to Google Sheets as a new row
Automatically send parsed JSON data to Google Sheets as a new row. Use HTTP to send data, parse JSON, and update Google Sheets.
Make$3.99Automate Sendcloud Label Creation from Google Sheets Entries
Automatically generate Sendcloud parcels and labels whenever a new row is added to a Google Sheets spreadsheet. This workflow streamlines the shipping process by integrating data directly from your spreadsheet.
Make$3.99Update Google Sheets rows based on new Shopify events
Automatically update Google Sheets rows when new Shopify events occur. Streamline data management by filtering and updating rows based on Shopify triggers.
Make$3.99Automate Multi-CRM Data Sync to Google Sheets with AI Deduplication
This workflow synchronizes contact data from HubSpot, Pipedrive, and Salesforce into Google Sheets, using AI to deduplicate and assess data quality. It runs on a schedule or can be manually triggered, ensuring a clean and up-to-date master database.
n8n$14.99Generate barcode from data in Google Sheets rows and save it to Dropbox
When a new row is added in Google Sheets spreadsheet, a new Barcode with data from the row is generated and the output file with the barcode is then uploaded to specified folder in Dropbox.
Make$3.99Create new entries in Award Force from new rows in Google Sheets
This template periodically checks for new rows in a source Google Sheet spreadsheet and uses the retrieved information to create new entries in Award Force. The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1AFt5BCMm_2Uz8vPSqqAZNJGEv2l4lO3HoOu0mS4K_o/edit?usp=sharing) You should make a copy of it before configuring the template. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template.
Make$2.99Log ManyChat Webhook Data to Google Sheets Automatically
Effortlessly capture and organize your ManyChat webhook data by adding it as new rows in Google Sheets, ensuring all chatbot interactions are systematically recorded.
Make$2.99Automate Twitter Sentiment Analysis with OpenAI, Google Sheets, and Slack Alerts
This workflow automates the monitoring of Twitter mentions, performs sentiment analysis using OpenAI, logs data in Google Sheets, and sends Slack alerts for negative tweets. It streamlines brand reputation management by eliminating manual monitoring.
n8n$9.99Create images from Google Sheets rows using Layerre and save to Google Drive
Automatically create images from Google Sheets data using Layerre and store the final files in Google Drive. This template eliminates the manual process of copying spreadsheet content into designs, exporting images, and uploading them to storage. The workflow starts with Google Sheets watching for new rows. Each row should contain text content and an image URL. Layerre then uses this data to generate an image based on your existing Canva design template. The generated image is downloaded via HTTP and automatically uploaded to a specified Google Drive folder for organised storage. Before using this template: - Create a Layerre template - Your Google Sheet must include columns for text and image URL. - Select or create a target folder in Google Drive for uploads. Example Google Sheets structure: https://docs.google.com/spreadsheets/d/1x8X_qZaoXkrIKGVlhCC25du8ht42UKinRPtmjThpTSE/edit?usp=sharing This template was created by Layerre. For questions or feedback, contact: hello@layerre.com
Make$4.99Add new Surveybot responses to a Google Sheets spreadsheet
Every time there is a new response in Surveybot, Make will automatically add a new row in Google Sheets spreadsheet for that response. The example uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1MyvsDU3ShjHZls1hpgHeBXZs7Y2dj0rEUvOdXNZICM/edit?usp=sharing).
Make$4.99Automate Data Insertion and Retrieval in Google Sheets
This workflow automates the process of inserting and retrieving data from Google Sheets, streamlining data management tasks.
n8n$4.99Create a new Google Sheets row for every answered RingCentral call
Every time a new call is answered in RingCentral, Make will automatically add that call's info to a new row in your Google Sheets spreadsheet.
MakeFreeAutomate Tadabase Record Export to Google Sheets
This workflow automates the export of Tadabase records to a Google Sheets spreadsheet, allowing for regular data synchronization at specified intervals.
Make$2.99Create new Google Sheets row from Airtable records when triggered by a Webhook
Every time a custom webhook is triggered, Make will automatically retrieve a record from Airtable using the output of the webhook. It will validate the email from the Airtable record. If the status of the email is valid it will add a new row to a Google Sheet. The webhook should have a field id otherwise the scenario will not be triggered.
Make$4.99Automate Lead Nurturing with Google Sheets and Apollo Enrichment
Efficiently manage and enrich your leads using Google Sheets and Apollo's API for enhanced CRM performance.
n8n$12.99Add new Service Provider Pro orders to a Google Sheets spreadsheet
Every time there is a new order in Service Provider Pro, Make will automatically add this order to a Google Sheets spreadsheet as new row. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/10nODw2DmXjhhWH7Cgp1Swxrodxu5b_1dtr5KJWw2ZVs/edit?usp=sharing).
Make$2.99Automate School Notices via WhatsApp, Email & Google Sheets
Automates daily distribution of school notices to students, parents, and staff via WhatsApp and email, pulling data from Google Sheets and updating status.
n8n$16.99
More integrations
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work