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.
Sync ActiveCampaign analytics to Google Sheets
Automatically sync your ActiveCampaign analytics to Google Sheets to enhance your marketing campaigns. his template transfers key performance metrics every Friday, allowing you to access fresh insights at the start of each week. Optimize your strategies with up-to-date data, reduce manual tasks, and improve decision-making efficiency. Ideal for teams looking for a streamlined approach to campaign tracking and analysis. he scenario runs every Friday (feel free to change the schedule if needed). You can change this in the scheduling settings by clicking the clock icon.
Make$2.99Sync Tasks Between Airtable, Asana, and Google Sheets
This Zap automates the process of managing tasks across multiple platforms by creating a seamless workflow between Airtable, Asana, and Google Sheets. It allows users to automatically create new records in Airtable, find specific sections in Asana, look up rows in Google Sheets, and update tasks in Asana, ensuring that all task-related information is synchronized and up-to-date. This integration saves time and reduces the risk of errors, enabling teams to focus on their work instead of manual data entry.
Zapier$3.99Track GitHub Node Definitions and Export to Google Sheets
# Track n8n Node Definitions from GitHub and Export to Google Sheets ## Overview This workflow automatically retrieves and processes metadata from the official n8n GitHub repository, filters all available `.node.json` files, parses their structure, and appends structured information into a Google Sheet. Perfect for developers, community managers, and technical writers who need to maintain up-to-date information about n8n's evolving node ecosystem. ## Setup Instructions ### Prerequisites Before setting up this workflow, ensure you have: - A GitHub account with API access - A Google account with Google Sheets access - An active n8n instance (cloud or self-hosted) ### Step 1: GitHub API Configuration 1. Navigate to GitHub Settings → Developer Settings → Personal Access Tokens 2. Generate a new token with `public_repo` permissions 3. Copy the generated token and store it securely 4. In n8n, create a new GitHub API credential 5. Paste your token in the credential configuration and save ### Step 2: Google Sheets Setup 1. Create a new Google Sheets document 2. Set up the following column headers in the first row: - `node` (Column A) - Node identifier/name - `nodeVersion` (Column B) - Version of the node - `codexVersion` (Column C) - Codex version number - `categories` (Column D) - Node categories - `credentialDocumentation` (Column E) - Credential documentation URL - `primaryDocumentation` (Column F) - Primary documentation URL 3. Note down the Google Sheets document ID from the URL 4. Configure Google Sheets OAuth2 credentials in n8n ### Step 3: Workflow Configuration 1. Import the workflow into your n8n instance 2. Update the following placeholder values: - Replace `YOUR_GOOGLE_SHEETS_DOCUMENT_ID` with your actual document ID - Replace `YOUR_WEBHOOK_ID` if using webhook functionality 3. Configure the GitHub API credentials in the HTTP Request nodes 4. Set up Google Sheets credentials in the Google Sheets nodes 5. Share your Google Sheets document with the email address associated with your Google OAuth2 credentials 6. Grant Editor permissions to allow the workflow to write data ## Google Sheets Template Details The workflow creates a structured dataset with these columns: - **node**: Node identifier (e.g., `n8n-nodes-base.slack`) - **nodeVersion**: Version of the node (e.g., `1.0.0`) - **codexVersion**: Codex version number (e.g., `1.0.0`) - **categories**: Node categories (e.g., `Communication, Productivity`) - **credentialDocumentation**: URL to credential documentation - **primaryDocumentation**: URL to primary node documentation ## Customization Options ### Modifying Data Extraction You can customize the Format Data node to extract additional fields: - Add new assignments in the Set node - Modify the column mapping in the Google Sheets node - Update your spreadsheet headers accordingly ### Changing Update Frequency To run this workflow on a schedule: 1. Replace the Manual Trigger with a Cron node 2. Set your desired schedule (e.g., daily, weekly) 3. Configure appropriate timing to avoid API rate limits ### Adding Filters Customize the Filter Node Files code node to: - Filter specific node types - Include/exclude certain categories - Process only recently updated nodes ## Features - Fetches all node definitions from the `n8n-io/n8n` repository - Filters for `.node.json` files only - Downloads and parses metadata automatically - Extracts key fields like node names, versions, categories, and documentation URLs - Appends structured data to Google Sheets with batch processing - Includes error handling and retry mechanisms - Clears existing data before appending new information for fresh results ## Use Cases This workflow is ideal for: - Tracking changes in official n8n node definitions over time - Auditing node categories and documentation links for completeness - Building custom dashboards from node metadata - Community management and documentation maintenance - Integration planning and compatibility analysis
n8n$14.99Parse XML and Populate Google Sheets with Structured Data
This workflow automates the process of downloading an XML file, parsing its contents, and storing the structured data in a Google Sheets spreadsheet.
n8n$9.99Automatically Add New ServiceM8 Clients from Google Sheets Entries
This workflow automates the process of creating new clients in ServiceM8 whenever a new row is added to a specified Google Sheets document. It streamlines client management by ensuring that your ServiceM8 database is always up-to-date with the latest client information.
Make$2.99Automate Wave Transactions from Google Sheets Entries
Automatically create accounting transactions in Wave for each new row added to your Google Sheets. This workflow helps streamline your financial record-keeping by exporting bank or credit card statements directly to Wave.
Make$2.99Streamline Zillow Property Data to Google Sheets with Budget Filters
Effortlessly extract and filter Zillow property listings by budget, then organize them in Google Sheets for real-time updates. Perfect for realtors and investors seeking accurate, up-to-date property information.
n8n$4.99Synchronize Google Sheets Metrics with Orbit Members and Activities
Effortlessly sync member and activity data from Google Sheets to Orbit, ensuring your community metrics are always up-to-date.
n8n$4.99Get notified of project status updates in Google Sheets
This Zap automates the process of updating project statuses in Dubsado and synchronizing that information with Google Sheets. When a project status is updated in Dubsado, this Zap filters the update, formats the date, looks up the corresponding row in Google Sheets, and updates the row with the new status. This ensures that your project management data is always current and accurate, saving you time and reducing the risk of errors.
Zapier$4.99Automate AI-Powered Responses with Google Sheets, OpenAI, and Supabase
This workflow automates the generation of intelligent AI responses by integrating Google Sheets, OpenAI, and Supabase. It retrieves user messages, processes them with AI, and updates the responses back into Google Sheets.
n8n$14.99Automatically Log New Memberful Signups to Google Sheets
Seamlessly track new Memberful signups by automatically adding their details to a Google Sheets document. This workflow ensures you have an up-to-date record of all new members.
Make$2.99Automatically Add New Tapfiliate Affiliates to Google Sheets
Streamline your affiliate management by automatically adding new Tapfiliate affiliates to a Google Sheets document, ensuring all affiliate information is organized and up-to-date.
Make$2.99YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI
# YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI --- ### Who Should Use This? Influencers, marketers, and data teams who need **instant insights** into audience sentiment without manual exports or scattered tools. --- ### The Challenge - **Manual exports** from YouTube Studio - **Time-consuming** sentiment tagging - **Data scattered** across multiple platforms Our workflow automates **everything**: from fetching comments to logging analysis—so you can focus on insights, not spreadsheets. --- ### What You'll Get 1. **Dynamic Input** Read a list of YouTube URLs from your Google Sheet. 2. **Full Comment Harvest** Pull **all** top-level comments (handles pagination 100/page). 3. **Deep Sentiment Scan** Classify each comment as **Positive**, **Neutral**, or **Negative** using OpenAI. 4. **Smart Formatting** Capture metadata (author, likes, timestamp) alongside sentiment. 5. **Seamless Storage** Append or update rows in your Google Sheet—ready for reporting. --- ### Easy Setup 1. **Prepare Google Sheet** - Create a sheet with a `video_urls` column (full YouTube links). - Add and authorize a Google Sheets OAuth or service-account credential in n8n. 2. **Enable YouTube API** - Activate Data API v3 in Google Cloud, grab an API key, and save as an HTTP credential in n8n. 3. **Configure OpenAI** - Enter your API key under the “OpenAI Chat” credential in n8n. 4. **Import the Workflow** - Paste the provided JSON into n8n. 5. **Run Manually** - Use the **Manual Trigger** node to start fetching and analyzing comments on demand. --- ### Customize to Your Needs - **Filter Comments**: Add an IF node to process only comments with specific keywords or minimum likes. - **Automate Schedule**: Swap the Manual Trigger for a Cron node if you later want periodic runs. - **Extended Analysis**: Swap sentiment classification for topic extraction, summarization, or translation by tweaking the LLM prompt. - **Alternate Destinations**: Replace Google Sheets with Airtable, Notion, or any database node. --- ### Tags ``YouTube`` ``Google Sheets`` ``OpenAI`` ``Sentiment Analysis`` ``n8n`` ``Manual Trigger``
n8n$14.99Sync New RepairShopr Customers to Google Sheets Automatically
Automatically transfer new customer data from RepairShopr to a Google Sheets spreadsheet, keeping your records up-to-date effortlessly.
MakeFreeAdd new WooCommerce customers to Google Sheets and subscribe them to AWeber
Retrieve all new WooCommerce customers, keep track of them in a Google Sheet and subscribe them to an AWeber email list for future marketing campaigns.
Make$3.99Filter the Feedback from Typeform and Store in Google Sheets
This workflow allows you to filter positive and negative feedback received from a Typeform and insert the data into Google Sheets.  **Typeform Trigger node:** Start the workflow when a new form is submitted via Typeform. **Set node:** Extract the information submitted in Typeform. **IF node:** Filter positive and negative reviews (i.e., ratings above or below 3 out of 5). **Google Sheets node:** Store the positive and negative reviews and ratings in two different sheets for each case.
n8n$4.99Automate Personalized Lead Nurturing with GPT-4.1 and Google Sheets
This workflow automates the process of sending personalized onboarding and follow-up emails based on lead commitment levels, helping coaches, consultants, and service-based businesses enhance their outreach and nurture prospects effectively.
n8n$9.99Automatically Log New WooCommerce Orders in Google Sheets
Automatically record each new order from WooCommerce into a Google Sheets spreadsheet, ensuring your order data is organized and easily accessible.
MakeFreeTemplate 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 Dynamic Variable Population for Retell Voice Agents Using Google Sheets
This workflow automates the process of populating dynamic variables for Retell Voice Agents by retrieving user data from Google Sheets based on incoming call information.
n8n$4.99Automate Shopify Discount Code Creation from Google Sheets
Automatically generate Shopify discount codes based on entries in a Google Sheet, streamlining your promotional workflows.
Make$3.99Automate WooCommerce Order Tracking to Google Sheets
Seamlessly track WooCommerce orders by automatically adding them to Google Sheets, ensuring your order data is organized and accessible in real-time.
Make$3.99Automate Invoice Creation in Vyfakturuj.cz from New Google Sheets Rows
Automatically generate invoices in Vyfakturuj.cz whenever a new row is added to a Google Sheets spreadsheet, streamlining your billing process.
MakeFreeAutomate Shopify Article Creation from Google Sheets Data
Streamline your e-commerce content management by automatically converting Google Sheets rows into Shopify articles. This workflow simplifies the process of updating your Shopify store with new content.
Make$2.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