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.99Automate LinkedIn Outreach with Unipile and Google Sheets
Streamline your LinkedIn outreach by automating contact requests and follow-up icebreakers using Unipile and Google Sheets.
n8n$19.99Automate Course Feedback Collection with Google Sheets and Typeform
Streamline your course feedback process by automatically transferring Typeform responses to Google Sheets based on feedback ratings.
n8n$12.3Automate 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.99Automate SEO Competitor Analysis with RapidAPI and Google Sheets
Streamline your SEO competitor analysis by capturing website domains via a user form, retrieving competitor data through RapidAPI, and logging results into Google Sheets. This workflow ensures data integrity with conditional checks and respects API rate limits with a built-in delay.
n8n$9.99Automated Security Threat Dashboard with Google Sheets and Email Alerts
This workflow aggregates security threat data from Google Sheets, analyzes it using AI, and sends detailed reports via email. Ideal for security teams seeking automated threat monitoring and reporting without a full SIEM setup.
n8n$14.99Automate Webflow Form Data Entry into Google Sheets
Streamline your workflow by automatically transferring Webflow form submissions to Google Sheets, ensuring organized and timely data logging.
n8n$4.99Automate Spending History Extraction from Gmail to Google Sheets
This workflow extracts spending details from Gmail and compiles them into a Google Sheet for easy tracking.
n8n$19.97Automate UTM-Tagged Bitly Link Creation from Slack with Google Sheets Logging
This n8n workflow automates the generation of Bitly links with UTM parameters directly from Slack messages. It uses AI to extract campaign data, creates a Bitly shortlink, and logs details in Google Sheets for tracking.
n8n$14.99Automate Lead Capture and Business Q&A with AI and Google Sheets
Streamline your business operations by automating lead capture and customer inquiries using AI-driven chatbots. This workflow integrates Google Drive, Pinecone, and Google Sheets to create a seamless system for managing company information and engaging with potential customers.
n8n$14.99Automate Daily Congratulations Messages with Twilio and Google Sheets
This workflow automatically sends personalized congratulations messages via SMS every day based on Google Sheets data.
n8n$18.32Automate Expense Extraction from Emails to Google Sheets
This workflow automatically processes emails with 'Expenses' or 'Receipt' in the subject, extracts relevant data, and appends it to a Google Sheet.
n8n$4.99Create an Invoice in Google Sheets Based on Typeform Submission
This n8n workflow triggers when a new Typeform submission is received. It extracts the data, creates a formatted invoice row in Google Sheets, and optionally sends a notification via Slack or an email. Conditional logic ensures only complete submissions are processed. Ideal for freelancers or small businesses needing to automate order-to-invoice steps without manual entry.
n8n$4.99Automate Trustpilot Review Scraping and Google Sheets Integration
This n8n workflow automates the process of scraping Trustpilot reviews using Bright Data and stores the structured data in Google Sheets for easy analysis and reporting.
n8n$14.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.99Automate LinkedIn Post Creation and Distribution from Google Sheets
Streamline your LinkedIn content strategy by automatically generating and posting updates from Google Sheets using OpenAI's GPT-4o. This workflow posts to both personal profiles and LinkedIn groups, ensuring efficient content distribution.
n8n$9.99Daily Updates to Google Sheets
This Zap automates the process of scheduling daily tasks and logging them into a Google Sheets document. By integrating Schedule by Zapier with Google Sheets, users can efficiently manage their daily activities, ensuring that important tasks are recorded and tracked without manual input. This streamlines workflow and enhances productivity by keeping all scheduled tasks organized in one place.
Zapier$2.99Automate LinkedIn Email Retrieval and Google Sheets Update
This workflow automates the process of retrieving email addresses from LinkedIn profiles and updating them in a Google Sheets document. It leverages the Prospeo.io LinkedIn Email Finder API to enrich LinkedIn profile data stored in Google Sheets.
n8n$9.99Automate Image Creation with Bannerbear and Google Sheets
This workflow automates the process of creating images in Bannerbear based on data inputted in Google Sheets. By monitoring new rows in a specified Google Sheets document, this integration allows users to automatically generate images tailored to ...
Make$12.99Automate OVH Invoice Management with Google Sheets and Drive
Streamline your OVH invoice management by automatically syncing invoices to Google Sheets and saving PDFs to Google Drive. This workflow eliminates the need to manually download invoices, saving you time and effort.
n8n$14.99Integrate Slack with Google Sheets for Product Ideas
This workflow facilitates the seamless integration of Slack and Google Sheets, allowing users to submit product ideas through a Slack command and automatically store them in a designated Google Sheets document. By setting up a Slack app with a cus...
n8n$14.99Automate Text Summarization and Logging with RapidAPI and Google Sheets
Effortlessly summarize large text blocks using the ext Summarizer AI API via RapidAPI and log the results in Google Sheets. Ideal for content creators, marketers, and researchers needing efficient summarization and record-keeping.
n8n$14.99Automate Data Synchronization from Google Sheets to PostgreSQL
Effortlessly synchronize data from Google Sheets to your PostgreSQL database. This workflow ensures data consistency by automating the retrieval, comparison, and updating of datasets.
n8n$9.99Effortlessly Scrape Business Leads from Google Maps with OpenAI and Google Sheets
This workflow automates the extraction of business leads from Google Maps, enhancing productivity and data management.
n8n$19.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