Google Sheets Automation Workflows
3,632 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.
Template 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.99Validate & Enrich Phone Numbers in Google Sheets with RapidAPI
### Phone Number Validator with Google Sheets Validate and enrich phone numbers from Google Sheets using the [`phone number validator`](https://rapidapi.com/skdeveloper/api/phone-number-validator11) API. --- ## Use Case: Contact Validation & Enrichment Automatically check if phone numbers are valid and enrich them with metadata (country, location, timezone). Ideal for CRMs, lead management, and contact cleanup workflows. --- ## Google Sheets Columns | Column Name | Description | |-------------|-------------| | `phone` | The original phone number to validate (input column). | | `is_valid` | Result from API indicating if the phone number is valid (`true` / `false`). | | `country` | Country where the phone number is registered (e.g., US). | | `location` | More specific location info, such as city or region. | | `timezone` | The primary timezone associated with the phone number. | --- ## Benefits - **Accurate Contact Data** - Identify invalid or fake phone numbers automatically. - **Geolocation Enrichment** - Add country, location, and timezone for better segmentation. - **Full Automation** - No manual lookups or copying data between tools. - **Live Google Sheets Sync** - Enriched data is updated directly into your spreadsheet. --- ## Workflow Nodes Explained | Node | Purpose | |------|---------| | **Manual Trigger** | Starts the workflow manually from n8n. | | **Google Sheets (Read)** | Fetches phone numbers from your spreadsheet using a Service Account. | | **Split In Batches** | Loops over each row one at a time to handle individual API requests. | | **HTTP Request** | Sends phone number to [`phone number validator`](https://rapidapi.com/skdeveloper/api/phone-number-validator11) via RapidAPI and receives validation + metadata. | | **Google Sheets (Update)** | Writes the response back into the matching row using the `phone` field. | --- ## API Used: `phone number validator` We use the [`phone number validator`](https://rapidapi.com/skdeveloper/api/phone-number-validator11) API from RapidAPI to: - Validate phone numbers (real or fake?) - Identify the **country**, **location**, and **timezone** > It's fast, reliable, and great for cleaning large datasets or qualifying leads before outreach. --- ## Prerequisites - A Google Sheet with a column named `phone` - RapidAPI key with access to `phone number validator` - Google Service Account credentials set up in n8n --- ## How to Use 1. Link your Google Sheet and configure authentication 2. Add your RapidAPI key in the HTTP node headers 3. Click Execute Workflow 4. Each phone number is validated and enriched 5. Results are written back to your Google Sheet --- ## Tags `phone validation`, `rapidapi`, `google sheets`, `data enrichment`, `phone number validator`, `crm automation`, `lead cleaning`, `timezone lookup`
n8n$9.99Create EZOfficeInventory fixed assets from new Google Sheets spreadsheet rows
A ready-to-use Make workflow that connects Google-sheets, Ezofficeinventory. Create EZOfficeInventory fixed assets from new Google Sheets spreadsheet rows. Customize and deploy in minutes.
Make$2.99Create a Google Docs and generate content using Perplexity AI and ChatGPT from Google Sheets data
A ready-to-use Make workflow that connects Google-sheets, Perplexity-ai, Openai-gpt-3. Create a Google Docs and generate content using Perplexity AI and ChatGPT from Google Sheets data. Customize and deploy in minutes.
Make$4.99Create a new Google Sheets row for every ChatGPT conversation with Perplexity AI
A ready-to-use Make workflow that connects Google-sheets, Perplexity-ai, Openai-gpt-3. Create a new Google Sheets row for every ChatGPT conversation with Perplexity AI. Customize and deploy in minutes.
Make$4.99Generate blog posts in WordPress using content from Google Sheets and ChatGPT Text and Images
A ready-to-use Make workflow that connects Google-sheets, Openai-gpt-3, Wordpress. Generate blog posts in WordPress using content from Google Sheets and ChatGPT Text and Images. Customize and deploy in minutes.
Make$4.99Get insights from Facebook Ads and add/update Google Sheets rows automatically
Automatically extract insights from Facebook Ads and update Google Sheets rows. Streamline data analysis and reporting with this powerful integration.
Make$3.99Create EZOfficeInventory users from new Google Sheets spreadsheet rows
Every time a new row is added to a Google Sheets spreadsheet, Make will automatically create a new user in EZOfficeInventory. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1wFvPwFQhexiwyC9nHoSbIB2CoE_6yZcQ281zBIt1ZRs/edit?usp=sharing).
Make$2.99Filter and update Google Sheets rows with data from HTML and send messages using Claude AI
A ready-to-use Make workflow that connects Google-sheets, Http, Regexp. Filter and update Google Sheets rows with data from HTML and send messages using Claude AI. Customize and deploy in minutes.
Make$4.99Save new WooCommerce orders to a Google Sheets spreadsheet
A ready-to-use Make workflow that connects Woocommerce, Google-sheets. Save new WooCommerce orders to a Google Sheets spreadsheet. Customize and deploy in minutes.
Make$2.99Filter and update Google Sheets rows with ChatGPT image and text generation
A ready-to-use Make workflow that connects Google-sheets, Openai-gpt-3. Filter and update Google Sheets rows with ChatGPT image and text generation. Customize and deploy in minutes.
Make$4.99Create a sales receipt in QuickBooks from customer details in a Google Sheets spreadsheet.
Every time a customer's details are added to a Google Sheet, Make retrieves the info and creates a sales receipt in QuickBooks. If its a new customer, the customer is first added to QuickBooks and then a receipt is created. The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1Ie8njl21Ob0cyugwb4qg_HIX53qsJAeph2vrLxvq9ww/edit#gid=0/xxx)
Make$3.99Update Google Sheets rows with responses from ChatGPT based on new data inputs
A ready-to-use Make workflow that connects Google-sheets, Openai-gpt-3, Json. Update Google Sheets rows with responses from ChatGPT based on new data inputs. Customize and deploy in minutes.
Make$4.99Create engaging Pinterest pins from Google Sheets data using ChatGPT
A ready-to-use Make workflow that connects Google-sheets, Openai-gpt-3, Pinterest. Create engaging Pinterest pins from Google Sheets data using ChatGPT. Customize and deploy in minutes.
Make$4.99Create Zoho Books vendors from a Google Sheets spreadsheet
A ready-to-use Make workflow that connects Google-sheets, Zoho-books. Create Zoho Books vendors from a Google Sheets spreadsheet. Customize and deploy in minutes.
Make$2.99Update a row in Google Sheets for every ChatGPT completion from a custom webhook
A ready-to-use Make workflow that connects Gateway, Openai-gpt-3, Google-sheets. Update a row in Google Sheets for every ChatGPT completion from a custom webhook. Customize and deploy in minutes.
Make$3.99Auto-Classify Security Incidents with GP-4 and Google Sheets for SOC Teams
## ☀ Who it's for Blue team leads, SOC analysts, and IR responders looking to automatically classify security alerts using AI-driven logic and asset-based risk signals. Ideal for teams already scoring threats via CyberScan or BlueOps Module 3, and needing to prioritize next steps across Monitor / Investigate / Isolate / Escalate playbooks. ## ℹ How it works / What it does - Reads recent endpoint alerts from Google Sheets - Sends alert data (hostname, IP, risk score) to OpenAI GP model - GP returns structured JSON with: - severity tag (Low / Medium / High / Critical) - action recommendation (Monitor / Investigate / Isolate / Escalate) - Logs the full result to a centralized incident sheet - Can be expanded to trigger automated EDR actions or email alerts ## ⚙ How to set up - Insert OpenAI API Key - Replace placeholder with your actual OpenAI secret in the HTTP Request node - Connect Sheets - Use your OAuth2 credentials to access the alerts input + classified log sheet - Tune GP Prompt - Adjust language or risk thresholds inside the Classify Incident (GP) node - Automation - Add a Cron node or Webhook to run every X minutes/hours ## 📋 Requirements - OpenAI API key (GP-4 or GP-3.5 supported) - Google Sheets (or similar DB with alerts) - n8n credentials for Sheets access - Optional: Connected playbook actions or EDR endpoint logic ## © How to customize the workflow - Swap GP with Claude, Gemini, or local LLM via API - Replace Google Sheets with Supabase or Airtable - Add a playbook router for Notify / Isolate logic - Integrate email or ticketing notification step ## ✨ This is a production-grade, AI-powered classification engine. All inputs and tags are configurable. Safe placeholders are marked clearly. ## ✨ This module is part of the CYBERPULSE BlueOps Pro automation suite. Explore the full set at ☀️🌐 cyberpulsesolutions.com/blueops
n8n$4.99Automated Stale User Re-Engagement System with Supabase, Google Sheets, & Gmail
Built this workflow because most of our users signed up, then vanished after ~30 days. It runs daily, grabs those stale users from Supabase, updates a Google Sheet for tracking, and automatically sends each one a personalized HTML email through Gmail to bring them back. All fully automated - so once it's set up, it quietly does its job in the background. Currently, it only supports Supabase, but the concept should work with any DB or API if you swap out the request node.
n8n$9.99Validate e-mail addresses by MailerCheck 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 by MailerCheck and create new customer in Shopify. The example uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1fv2rIpK2JastD7Npy6mrFepUwXHf9HlhcMvnybbP8kY/edit?usp=sharing).
Make$3.99Create a Wix product from a new Google Sheets row
A ready-to-use Make workflow that connects Google-sheets, Wix. Create a Wix product from a new Google Sheets row. Customize and deploy in minutes.
MakeFreeSave a Gmail email from a specific sender to Google Sheets as a new row
A ready-to-use Make workflow that connects Google-email, Google-sheets. Save a Gmail email from a specific sender to Google Sheets as a new row. Customize and deploy in minutes.
Make$2.99Send RingCentral SMS messages for new Google Sheets rows
A ready-to-use Make workflow that connects Google-sheets, Ringcentral. Send RingCentral SMS messages for new Google Sheets rows. Customize and deploy in minutes.
Make$2.99Make an API call to WooCommerce and update a row in Google Sheets
Automatically update Google Sheets with WooCommerce API data. Streamline data management by syncing WooCommerce updates directly to your Google Sheets rows.
Make$2.99Make an API call to WooCommerce and add a new row in Google Sheets
Automatically update your Google Sheets with new data from WooCommerce API calls. Streamline data management by integrating WooCommerce and Google Sheets effortlessly.
Make$3.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