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.
Validate e-mail addresses and phone numbers by Loqate and create new customers in Shopify for new Google Sheets rows
Every time a new row is added to a Google Sheet, Make will automatically validate the email address and phone nubmer by Loqate and create new customer in Shopify. The example uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1t_QPI-4JMX21JCydPvSqjSnzR9HLNgZ1I-birJvmfnU/edit?usp=sharing).
Make$4.99Streamline Your Health Metrics with Google Sheets and Orbit Integration
This workflow automates the process of transferring health metrics from Google Sheets to Orbit, enabling seamless management of member data and activities. It begins by fetching member details from a Google Sheets document, ensuring that all data ...
n8n$13.97Automate Google Sheets Filtering and Reddit Post Submission
Effortlessly filter rows in Google Sheets and automatically submit relevant posts to Reddit, enhancing your content sharing efficiency.
MakeFreeSync New Google Sheets Contacts to Brevo Automatically
Effortlessly transfer new contact information from Google Sheets to Brevo, ensuring your contact list is always up-to-date.
MakeFreeAutomate Email Categorization and Tracking with AI and Google Sheets
Automatically categorize and track company emails using AI and update Google Sheets with categorized data for efficient request management.
n8n$9.99Fetch range values from Google Sheets and add a new row with ChatGPT responses
This automation fetches range value data from Google Sheets, generate responses using ChatGPT, and adds a new row to your sheet with new insights for streamlined data management.
Make$3.99Add new SendFox contacts to a Google Sheets spreadsheet as a new row
Every time a new contact is added to SendFox, Make will automatically add that contact to a new row in a Google Sheets spreadsheet.
MakeFreeConvert Google Sheets Data to Custom HTML Table via Webhook
This workflow transforms data from Google Sheets into a customizable HTML table using a webhook, allowing for dynamic web content generation.
n8n$4.99Save Hotmart Events to Google Sheets Automation
Automatically capture and log Hotmart events like purchases, refunds, subscriptions, and cart abandonments directly into Google Sheets for seamless tracking and analysis.
n8n$12.99Seamlessly Transfer Clockify Timesheets to Google Sheets
Automatically export your Clockify time entries to Google Sheets for streamlined data management and analysis.
MakeFreeAutomatically Add New Google Sheets Rows as SendX Contacts
Streamline your contact management by automatically creating SendX contacts whenever a new row is added to your Google Sheets spreadsheet.
MakeFreeGet ad account insights from Facebook and add them to Google Sheets
Automatically fetch Facebook ad account insights and add them to Google Sheets for streamlined data analysis and reporting.
Make$3.99Automated Daily Backup of Google Sheets to Google Drive
This workflow automates the daily backup of a Google Sheet by exporting its data and saving it as a CSV or XLSX file in a specified Google Drive folder. It ensures data redundancy and maintains historical versions for critical business data.
n8n$4.99Enrich Company Domains with Perplexity AI & Google Sheets
Automates enriching company domains with business data using Perplexity AI, batching for efficiency, and storing in Google Sheets. Perfect for sales, marketing, and lead generation teams.
n8n$22.99Add Google Sheets rows for new Amazon SES contacts
Make will watch your Amazon SES contacts and add them to your Google Sheets as rows. Heres the [spreadsheet](https://docs.google.com/spreadsheets/d/1FeaALMYAUmUlQssrMVCIyvojkX5V9tpNXgo9rS_9egA/edit?usp=sharing) used in this scenario.
Make$2.99Create Pipefy table records from new Google Sheets rows
Every time a new row is added in a Google Sheets spreadsheet, Make will automatically create a new record in your Pipefy table.
MakeFreeSeamlessly Sync New Google Sheets Contacts to Mailjet
Automatically add new contacts from Google Sheets to Mailjet, ensuring your email list is always up-to-date. This workflow captures email addresses and names from specified columns.
Make$2.99Upload new click conversions into Google Ads from new rows in a Google Sheets spreadsheet
A ready-to-use Make workflow that connects Google-sheets, Google-ads-conversions. Upload new click conversions into Google Ads from new rows in a Google Sheets spreadsheet. Customize and deploy in minutes.
Make$3.99Add new Square refunds to a Google Sheets spreadsheet as new rows
Every time there is a new refund in Square, Make will automatically add that refunds info to a new row in your Google Sheets spreadsheet. The template uses this [example spreadsheet](http://bit.ly/2VX4Eog).
Make$2.99Automate WhatsApp Messaging and Google Sheets Logging for New Facebook Leads
Streamline your lead management by automatically sending personalized WhatsApp messages to new Facebook Lead Ads entries and logging their details in Google Sheets.
Make$3.99Template for TikTok, RapidAPI, and Google Sheets Services
### TikTok Account Monitoring Automation This n8n workflow automates the daily process of fetching TikTok account analytics using the [**TikTok API**](https://rapidapi.com/skdeveloper/api/tiktok-api42) and logging the results to **Google Sheets**. It helps marketing teams, social media managers, and influencer agencies track video performance and audience growth across multiple TikTok usernames without manual effort. --- ## Workflow Summary 1. **Trigger via Schedule** - The workflow runs automatically every day (or any custom interval), ensuring data is consistently updated without manual input. 2. **Sheet 1 - Read TikTok Usernames** - A Google Sheet stores the list of TikTok usernames you want to monitor. - Example Columns: - `username` - `category` - `priority` - `notes` 3. **Loop Through Each Username** - Each username is processed individually in a loop to make separate API calls and avoid data conflicts. 4. **Fetch Analytics via RapidAPI** - The following [**TikTok API**](https://rapidapi.com/skdeveloper/api/tiktok-api42) endpoint is used: [**`POST https://tiktok-api42.p.rapidapi.com/videos_view_count.php`**](https://rapidapi.com/skdeveloper/api/tiktok-api42) - You get per-user stats like: - Number of videos - Total views - Recent video views - This endpoint is highly stable and works without TikTok login or auth. 5. **Sheet 2 - Append Analytics Results** - Fetched data is logged in another Google Sheet for performance tracking. - Example Columns: - `username` - `total_videos` - `total_views` - `average_views` - `fetch_date` - `category` 6. **Sheet 3 - Log API History or Errors** - A third sheet stores logs of API fetch status, failures, or skipped usernames for debugging. - Example Columns: - `username` - `status` (e.g., success, failed, skipped) - `message` - `timestamp` --- ## RapidAPI Notes - You must have an API key from [**TikTok API**](https://rapidapi.com/skdeveloper/api/tiktok-api42) - All requests are made to [**`https://tiktok-api42.p.rapidapi.com`**](https://rapidapi.com/skdeveloper/api/tiktok-api42) - The main endpoint in use is: [**`POST https://tiktok-api42.p.rapidapi.com/videos_view_count.php`**](https://rapidapi.com/skdeveloper/api/tiktok-api42) - Each request uses `POST` with params like `username`, `region`, `number` - The response is JSON and easy to parse in n8n workflows --- ## Optional Extensions (Same API, More Insights) This same [**TikTok API**](https://rapidapi.com/skdeveloper/api/tiktok-api42) also supports other advanced endpoints that can be added to enrich your workflow: | Endpoint Name | Functionality | |------------------------|------------------------------------------------------------| | **User Profile Data** | Get bio, profile image, followers, likes, etc. | | **User Account Stats** | Extract detailed user metrics (likes, comments, shares) | | **User Audience Stats**| Know where their followers are from and gender split | | **Historical Data** | Track historical performance trends (useful for growth charts) | | **Hashtags Scraper** | Find trending or related hashtags used by the user | | **Related User Info** | Suggest accounts similar to the one queried | | **Videos Views Counts**| Already used to get view stats for multiple videos | Each of these can be added using **`HTTP Request`** nodes in n8n and plugged into the same sheet or separate ones. --- ## Benefits - **Fully Automated**: No manual copy-paste or login required - **Centralized Analytics**: Track all creators or clients in one dashboard - **Performance Insights**: Daily growth visibility with historical tracking - **Data Export Ready**: Stored in Google Sheets for easy share/report/export - **Scalable & Flexible**: Add hashtags, followers, or audience demographics --- ## Use Cases - **Influencer Agencies** tracking clients' TikTok growth daily - **Brands running UGC Campaigns** who want to monitor video traction - **Analysts** building dashboards from Sheet-to-DataStudio/Looker - **Marketers** analyzing viral trends or creators across niches --- ## Final Note This workflow is extendable. You can: - Merge multiple endpoints per user - Schedule it weekly or monthly - Send email summaries - Push to Slack or Google Data Studio > API Used in this workflow: > [**TikTok API**](https://rapidapi.com/skdeveloper/api/tiktok-api42)
n8n$9.99Get Slack Notifications for Jira Issues with Google Sheets Tracking
This Zap automates the process of managing Jira issues by integrating multiple tools to streamline communication and updates. When a specific issue is identified in Jira, it triggers a Python script to process the data, looks up relevant information in Google Sheets, and filters the results. If the conditions are met, it adds a comment to the Jira issue and sends a message to a designated Slack channel, ensuring that your team stays informed and aligned on project updates.
Zapier$4.99Automate Lead Follow-Up from Gmail Using AI, HubSpot, Slack, and Google Sheets
Streamline your lead management by automating follow-up tasks for new Gmail leads using AI analysis, HubSpot task creation, Slack notifications, and Google Sheets logging.
n8n$9.99Log Food Calories from Images to Google Sheets via LINE & OpenAI Vision
LINE bot receives food images or text, uses OpenAI Vision to estimate calories, logs to Google Sheets, and replies to users instantly.
n8n$22.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