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.
Automated SEO Keyword Analysis with RapidAPI and Google Sheets
## Automated Keyword Analysis with On-Page SEO Workflow ### Description Boost your SEO strategy by automating keyword research and on-page SEO analysis with n8n. This workflow uses user input (keyword + country), retrieves essential data using the powerful [**SEO On-Page API**](https://rapidapi.com/PrineshPatel/api/seo-on-page), and saves it directly into Google Sheets. Ideal for marketers, content strategists, and SEO agencies looking for efficiency. --- ## Node-by-Node Flow Explanation ### 1. **On Form Submission** Triggers the workflow when a user submits a keyword and country via a simple form. ### 2. **Global Storage** Captures and stores the submitted keyword and country for use across the workflow. ### 3. **Keyword Insights Request** Sends a POST request to the [**SEO On-Page API**](https://rapidapi.com/PrineshPatel/api/seo-on-page) to fetch keyword suggestions (broad match keywords). ### 4. **Re-Format** Extracts the relevant `broadMatchKeywords` array from the keyword API response. ### 5. **Keyword Insights** Appends extracted keyword suggestions into the **Keyword Insights** tab in Google Sheets. ### 6. **Keyword Difficulty Request** Sends a second POST request to the [**SEO On-Page API**](https://rapidapi.com/PrineshPatel/api/seo-on-page) to fetch keyword difficulty and SERP data. ### 7. **Re-Format 2** Extracts the `keywordDifficultyIndex` value from the API response. ### 8. **Keyword Difficulty** Saves the keyword difficulty score into the **Keyword Difficulty** sheet for reference. ### 9. **Re-Format 5** Extracts SERP result data from the difficulty API response. ### 10. **SERP Result** Appends detailed SERP data into the **Serp Analytics** sheet in Google Sheets. --- ## Benefits - **Fully Automated SEO Research** - No manual data entry or API calls required. - **Real-time Data Collection** - Powered by [**SEO On-Page API on RapidAPI**](https://rapidapi.com/PrineshPatel/api/seo-on-page), ensuring fresh and reliable results. - **Organized Insights** - Data is cleanly categorized into separate Google Sheets tabs. - **Time Saver** - Instantly analyze keywords without switching between tools. --- ## Use Cases - **SEO Agencies** - Generate keyword reports for clients automatically. - **Content Writers** - Discover keyword difficulty and SERP competition before drafting. - **Digital Marketers** - Monitor keyword trends and search visibility in real-time. - **Bloggers & Influencers** - Choose better keywords to rank faster on search engines. --- ## API Reference This workflow is powered by the **[SEO On-Page API](https://rapidapi.com/PrineshPatel/api/seo-on-page)** available on RapidAPI. It offers keyword research, difficulty metrics, and SERP analytics through simple endpoints, making it ideal for automation with n8n. --- > **Note:** Make sure to replace `your key` with your actual RapidAPI key in both HTTP Request nodes for successful API calls. Create your **free n8n account** and set up the workflow in just a few minutes using the link below: [Start Automating with n8n](https://n8n.partnerlinks.io/7fuarh1e6dz5) Save time, stay consistent, and grow your LinkedIn presence effortlessly!
n8n$14.99Automate Lead Generation from Social Engagement with Rigify, Google Sheets, and Slack
This workflow automates the process of generating leads by monitoring social media engagement, enriching prospect data, and notifying teams via Slack for immediate action.
n8n$9.99Automate YouTube Video Optimization with Google Sheets and DeepSeek AI
Enhance your YouTube channel's visibility by automating video title and description optimization using Google Sheets and DeepSeek AI. This workflow streamlines the process of managing video data and generating SEO-friendly content.
n8n$9.99Automate QuickBooks Customer and Estimate Creation from Google Sheets
Streamline your sales process by automatically creating new customers and estimates in QuickBooks from Google Sheets entries. This workflow reduces manual data entry, minimizes errors, and keeps your financial records current.
n8n$14.99Automate Twitter Brand Promotion with AI and Google Sheets Reporting
This n8n workflow automates brand promotion by generating human-like responses to Twitter posts using Anthropic Claude AI and logs the interactions in Google Sheets for tracking.
n8n$14.99Automate Multi-Platform Social Media Lookup from Google Sheets with Gemini AI
## Who's it for This template is designed for **campaigners, researchers, and organizers who need to enrich spreadsheets of contacts with publicly available social media profiles**. Ideal for advocacy campaigns, outreach, or digital organizing where fast, scalable people lookup is needed. ## What it does This workflow scans a Google Sheet for rows marked as unanalysed (`Analysed? = false`), sends each contact to a dedicated AI-powered research agent, and returns structured public profile links across major platforms like: - Twitter/X - LinkedIn - Facebook - Instagram - GitHub - TikTok - YouTube - Reddit - Threads - Medium - Substack - And more (18+ total) It processes one contact per run for clarity and stability, appending the results back to the original Google Sheet. ## How to set it up 1. **Copy the [Google Sheet template](https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit?usp=sharing)**. This sheet includes sample columns and headers for contacts and social profile fields. 2. Paste your contact list at the end of the sheet. 3. For each new contact, make sure the **Analysed?** column is set to `false`. 4. Clone this workflow and [the AI Research Agent subworkflow](https://n8n.io/workflows/5588-multi-tool-research-agent-for-animal-advocacy-with-openrouter-serper-and-open-paws-db/). 5. Connect your Google Sheets account in n8n. 6. Update the workflow with your sheet ID and sheet name (`Sheet1` by default). 7. Trigger the workflow on a schedule (e.g., every 15 minutes) or run it manually. ## Requirements - **Google Sheets integration** set up in n8n - Access to [this AI research subworkflow](https://n8n.io/workflows/5588-multi-tool-research-agent-for-animal-advocacy-with-openrouter-serper-and-open-paws-db/) - OpenRouter API key - n8n (self-hosted or cloud) ## How to customize the workflow - Modify the research agent to prioritize specific platforms or return only verified profiles. - Add more profile columns to the Google Sheet and schema to match your custom fields. - Add logic to send alerts (email, Slack, etc.) for specific contacts. - Use an n8n webhook instead of a schedule to run the process on demand. - Use a loop over all items to process all rows sequentially (only recommended for small datasets due to memory constraints)
n8n$9.99Sync New Google Sheets Rows to Notion Database
Automatically create Notion database entries for each new row added to your Google Sheets, ensuring seamless data synchronization.
MakeFreeAutomate Prescription Delivery via Google Sheets to Email & WhatsApp
This is a fully working n8n workflow that sends prescriptions to patients via email and WhatsApp when a doctor enters prescription data into a Google Sheet. ## Google Sheets Structure **Main Sheet:** Required columns: - `prescription_id` (unique ID) - `patient_name` - `patient_email` - `patient_phone` - `doctor_name` - `prescription_date` - `prescription_details` - `dosage_instructions` - `followup_date` (optional) - `prescription_status` (set to new for new prescriptions) **Log Sheet:** This will be auto-created with columns for tracking sent notifications. ## Required Credentials Setup 1. **Google Sheets OAuth2 API**: Connect your Google account 2. **SMTP Credentials**: For email sending (Gmail, Outlook, etc.) 3. **WhatsApp API**: Meta Business WhatsApp API credentials ## Configuration Steps 1. Replace `YOUR_GOOGLE_SHEET_ID` with your actual Google Sheet ID 2. Replace `YOUR_WHATSAPP_PHONE_NUMBER_ID` with your WhatsApp Business phone number ID 3. Update the email sender address in the Send Email node 4. Set up your credentials in n8n ## Features Included - **Automated Trigger**: Monitors Google Sheet for new prescriptions - **Smart Filtering**: Only processes prescriptions with status new - **Rich Email Format**: Professional HTML email with prescription details - **WhatsApp Integration**: Sends formatted prescription text - **Comprehensive Logging**: Tracks all sent notifications - **Status Updates**: Marks prescriptions as sent after processing - **Error Handling**: Logs success/failure status for both channels ## Sample Data Format Add rows to your sheet like this: ``` prescription_id: RX001 patient_name: John Doe patient_email: john@email.com patient_phone: +1234567890 doctor_name: Dr. Smith prescription_date: 2025-01-15 prescription_details: Amoxicillin 500mg capsules dosage_instructions: Take 1 capsule 3 times daily with food followup_date: 2025-01-22 prescription_status: new ```
n8n$4.99Automate TikTok Video Transcription with RapidAPI and Google Sheets
# TikTok Transcript Generator ## Overview This automated workflow extracts transcripts from TikTok videos by reading video URLs from a Google Sheet, calling the **API via [TikTok Transcript Generator](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**, cleaning the subtitle data, and updating the sheet with transcripts. It efficiently handles batches, errors, and rate limits to provide a seamless transcription process. ## Key Features - **Batch processing:** Reads and processes multiple TikTok video URLs from Google Sheets. - **Automatic transcript generation:** Uses the **[TikTok Transcript Generator API on RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**. - **Clean subtitle output:** Removes timestamps and headers for clear transcripts. - **Error handling:** Marks videos with no available transcript. - **Rate limiting:** Implements wait times to avoid API throttling on **[RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**. - **Seamless Google Sheets integration:** Updates the same sheet with transcript results and statuses. ## API Used - **[TikTok Transcript Generator API](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)** ## Google Sheet Columns | Column Name | Description | |----------------|-----------------------------------------------| | Video Url | URL of the TikTok video to transcribe | | Transcript | Generated transcript text (updated by workflow) | | Generated Date | Date when the transcript was generated (YYYY-MM-DD) | ## Workflow Nodes Explanation | Node Name | Type | Purpose | |-------------------------|-----------------------|-----------------------------------------------------------------------| | When clicking “Execute workflow” | Manual Trigger | Manually starts the entire transcription workflow. | | Google Sheets2 | Google Sheets (Read) | Reads TikTok video URLs and transcript data from Google Sheets. | | Loop Over Items | Split In Batches | Processes rows in smaller batches to control execution speed. | | If | Conditional Check | Filters videos needing transcription (URL present, transcript empty). | | HTTP Request | HTTP Request | Calls the **TikTok Transcript Generator API on [RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)** to fetch transcripts. | | If1 | Conditional Check | Checks for valid API responses (handles 404 errors). | | Code | Code (JavaScript) | Cleans and formats raw subtitle text by removing timestamps. | | Google Sheets | Google Sheets (Update)| Updates the sheet with cleaned transcripts and generation dates. | | Google Sheets1 | Google Sheets (Update)| Updates sheet with “No transcription available” message on error. | | Wait | Wait | Adds delay between batches to avoid API rate limits on **[RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**. | ## Challenges Resolved - **Manual Transcription Effort:** Eliminates the need to manually transcribe TikTok videos, saving time and reducing errors. - **API Rate Limits:** Introduces batching and wait periods to avoid exceeding API usage limits on **[RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**, ensuring smooth execution. - **Incomplete or Missing Data:** Filters out videos already transcribed and handles missing transcripts gracefully by logging appropriate messages. - **Data Formatting Issues:** Cleans raw subtitle data to provide readable, timestamp-free transcripts. - **Data Synchronization:** Updates transcripts back into the same Google Sheet row, maintaining data consistency and ease of access. ## Use Cases - Content creators wanting to transcribe TikTok videos automatically. - Social media analysts extracting text data for research. - Automation enthusiasts integrating transcript generation into workflows. ## How to Use 1. Prepare a Google Sheet with the columns: **Video Url**, **Transcript**, and **Generated Date**. 2. Connect your Google Sheets account in the workflow. 3. Enter your **RapidAPI** key for the TikTok Transcript Generator API. 4. Execute the workflow to generate transcripts. 5. View transcripts and generated dates directly in your Google Sheet. --- **Try this workflow to automate your TikTok video transcriptions efficiently!** Create your **free n8n account** and set up the workflow in just a few minutes using the link below: ☀️🌟 [Start Automating with n8n](https://n8n.partnerlinks.io/7fuarh1e6dz5) Save time, stay consistent, and grow your LinkedIn presence effortlessly!
n8n$14.99Automate Instagram Comment Responses with Google Sheets and CRM Integration
This n8n workflow automates the response to Instagram comments using predefined messages stored in Google Sheets, while logging interactions for CRM purposes.
n8n$9.99Automate Sending Personalized Emails from Google Sheets with SendGrid
This n8n workflow automates the process of sending personalized emails using predefined templates stored in Google Sheets, leveraging SendGrid for email delivery. It ensures consistent and efficient email personalization without the need for AI-generated content.
n8n$9.99Automatic Event Creation in Google Calendar from Google Sheets Data
This workflow streamlines the process of creating events in Google Calendar using event data stored in a Google Sheet. The process begins by retrieving the latest event entry from Google Sheets, ensuring only the most recent event details are processed. Once fetched, a Function node formats the event date to align with Google Calendar's required format, ensuring consistency and preventing date-related errors. After formatting, the structured event details are sent to Google Calendar, where an event is created with essential information such as the event title (summary), description, date, and location. Additionally, the workflow allows customization by setting the event's status as either Busy or Available, helping attendees manage their schedules. A background color can also be assigned for better visibility and categorization. By automating this process, you eliminate the need for manual event creation, ensuring seamless synchronization between Google Sheets and Google Calendar. This improves efficiency, accuracy, and productivity, making event management effortless. ## Prerequisites **Before setting up this workflow, ensure the following:** - You have an active Google account connected to Google Sheets and Google Calendar. - The Google Sheets API and Google Calendar API are enabled in the Google Cloud Console. - n8n has the necessary OAuth2 authentication configured for both Google Sheets and Google Calendar. - Your Google Sheet has columns for event details (event name, description, location, date, etc.). | Event Name | Event Description | Event Start Date | Location | |------------|-------------------|------------------|----------| | Birthday | Celebration | 27-Mar-1989 | City | | Anniversary| Celebration | 10-Jun-2015 | City | ## Customization Options - Modify the Google Sheets trigger to track updates in specific columns. - Adjust the data formatting function to support: - Different date/time formats - Time zone settings - Custom event colors - Attendee invitations ## Steps ### Step 1: Add the Google Sheets Trigger Node - Click Add Node and search for Google Sheets. - Select Google Sheets Trigger and add it to the workflow. - Authenticate using your Google account (select an existing account if already authenticated). - Select the Spreadsheet and Sheet Name to monitor. - Set the Trigger Event to Row Added. - Click Execute Node to test the connection. - Click Save. ### Step 2: Process Data with Function Node - Click Add Node and search for Function. - Add the Function Node and connect it to the Google Sheets Trigger Node. - In the function editor, write a script to extract and format data. - Ensure the required fields (title, location, date) are properly structured. - Click Execute Node to verify the formatted output. - Click Save. ### Step 3: Add the Google Calendar Node - Click Add Node and search for Google Calendar. - Select Create Event operation. - Authenticate with Google Calendar. - Map the required fields - Title - Description - Location - Start time - Optional: Set Event Status and Event Colors. - Click Execute Node to test event creation. - Click Save. ### Step 4: Final Steps - Connect all nodes in sequence (Google Sheets Trigger → Function Node → Google Calendar Node). - Test the workflow by adding a sample row in Google Sheets. - Verify that the event is created in Google Calendar with the correct title, description, date, and location. ## About WeblineIndia This workflow was built by the [AI development](https://www.weblineindia.com/ai-development.html) team at WeblineIndia. We help businesses automate processes, reduce repetitive work, and scale faster. Need something custom? You can [hire AI developers](https://www.weblineindia.com/hire-ai-developers.html) to build workflows tailored to your needs.
n8n$4.99Automate Personalized Icebreakers Using Google Sheets and AI
Streamline your cold outreach by generating personalized icebreakers using Google Sheets, web scraping, and AI. Ideal for sales teams and agencies aiming to enhance engagement with tailored messages.
n8n$9.99Convert JSON Data to Google Sheets Entries
This workflow reads JSON data from a file and appends it to a Google Sheets document, enabling seamless data transfer and storage.
n8n$3.99Add New Incoming Emails to a Google Sheets Spreadsheet as a New Row
This n8n workflow automates the process of capturing and storing incoming email details in a structured spreadsheet format, such as Google Sheets or Excel. Whenever a new email is received, the workflow extracts key details—including the sender's email, subject, email body, and optional attachments—and logs them as a new row in the spreadsheet. You can customize this workflow to extract additional details, filter emails based on specific criteria, or send notifications when new entries are added. ## Pre-conditions & Requirements Before setting up this workflow, ensure that: - You have access to the email provider (e.g., Gmail, Outlook, or IMAP-supported email services). - The Gmail Node must be enabled in n8n. - You must authenticate n8n with Google OAuth2 to access your inbox. - Ensure that the Gmail API is enabled in the Google Cloud Console. - You have an existing Google Sheet where data will be stored. - The Google Sheets API is enabled. - You authenticate n8n with your Google account. ## Steps ### Step 1: Add the Gmail Trigger Node - Click on Add Node and search for Gmail. - Select Gmail Trigger and click to add it. - Under Authentication, click Create New and authenticate with your Google account. (If you have already connected your Google account, simply select it.) - In the Trigger Event field, select Message Received. - Under Filters, you can specify: - Label/Mailbox: If you want to listen to emails from a specific folder (optional). - From Address: If you only want to receive emails from specific senders (optional). - Click Execute Node to test the connection. - Click Save. **What This Does:** This node listens for new incoming emails in your Gmail inbox. ## Step 2: Store Email Data in Google Sheets - Click on Add Node and search for Google Sheets (or Microsoft Excel, if applicable). - Under Authentication, connect your Google account. - Select the target Spreadsheet and Sheet Name where the data will be stored. - Set the Operation to Append Row. - Map the extracted email data to the correct columns. - Click Execute Node to test and verify data storage. - Click Save. **What This Does:** This node automatically adds a new row for each incoming email, ensuring a structured and searchable email log. ## Final Step Attach both nodes and execute the workflow. ## Who's behind this? WeblineIndia's [AI development team](https://www.weblineindia.com/ai-development.html). We've delivered 3500+ software projects across 25+ countries since 1999. From no-code automations to complex AI systems - our AI team builds tools that drive results. Looking to [hire AI developers](https://www.weblineindia.com/hire-ai-developers.html)? Start with us.
n8n$4.99Automate Weekly Restaurant Forecasting with Google Sheets and Gemini AI
This n8n workflow automates the weekly forecasting of restaurant sales and inventory needs using historical data from Google Sheets and AI predictions from Google Gemini. The forecast is emailed to stakeholders for improved planning and waste reduction.
n8n$14.99Automate Daily Sales Insights and Team Notifications with Google Sheets and Gemini AI
Streamline your daily sales reporting by automating data collection, analysis, and team notifications using Google Sheets, Gemini AI, and various communication tools.
n8n$9.99Automate Airbnb Listing Scraping and Storage in Google Sheets
This n8n workflow automates the process of scraping Airbnb listings from a specified location and storing the data in Google Sheets. It handles pagination to gather listings from multiple pages, extracts detailed property information, and formats the data for easy analysis.
n8n$14.99Automate MySQL to Google Sheets Data Sync with Duplicate Prevention
This n8n workflow automates the synchronization of new records from a MySQL database to a Google Sheet every 15 minutes, ensuring no duplicates are transferred.
n8n$9.99Effortlessly Sync New Google Sheets Subscribers to MailerLite with Duplicate Prevention
Automate the process of syncing new subscribers from Google Sheets to MailerLite while preventing duplicates, ensuring your email lists remain clean and accurate.
n8n$9.99Extract and Structure Hair Documents to Google Sheets using Typhoon OCR and Llama 3.1
 **Note:** This template requires a community node and works **only on self-hosted** n8n installations. It uses the Typhoon OCR Python package and custom command execution. Make sure to install required dependencies locally. --- ## Who is this for? This template is for developers, operations teams, and automation builders in Thailand (or any Thai-speaking environment) who regularly process PDFs or scanned documents in Thai and want to extract structured text into a Google Sheet. ### It is ideal for: * Local government document processing * Thai-language enterprise paperwork * AI automation pipelines requiring Thai OCR --- ## What problem does this solve? Typhoon OCR is one of the most accurate OCR tools for Thai text. However, integrating it into an end-to-end workflow usually requires manual scripting and data wrangling. ### This template solves that by: * Running Typhoon OCR on PDF files * Using AI to extract structured data fields * Automatically storing results in Google Sheets --- ## What this workflow does 1. **Trigger**: Run manually or from any automation source 2. **Read Files**: Load local PDF files from a `doc/` folder 3. **Execute Command**: Run Typhoon OCR on each file using a Python command 4. **LLM Extraction**: Send the OCR markdown to an AI model (e.g., GPT-4 or OpenRouter) to extract fields 5. **Code Node**: Parse the LLM output as JSON 6. **Google Sheets**: Append structured data into a spreadsheet --- ## Setup ### 1. **Install Requirements** * Python 3.10+ * `typhoon-ocr`: `pip install typhoon-ocr` * Install [Poppler](https://github.com/oschwartz10612/poppler-windows/releases/) and add to system PATH (needed for `pdftoppm`, `pdfinfo`) ### 2. **Create folders** * Create a folder called `doc` in the same directory where n8n runs (or mount it via Docker) ### 3. **Google Sheet** Create a Google Sheet with the following column headers: | book_id | date | subject | detail | signed_by | signed_by2 | contact | download_url | | -------- | ---- | ------- | ------ | ---------- | ----------- | ------- | ------------- | You can use this [example Google Sheet](https://docs.google.com/spreadsheets/d/1h70cJyLj5i2j0Ag5kqp93ccZjjhJnqpLmz-ee5r4brU) as a reference. ### 4. **API Key** Export your `TYPHOON_OCR_API_KEY` and `OPENAI_API_KEY` in your environment (or set inside the command string in `Execute Command` node). --- ## How to customize this workflow * Replace the LLM provider in the `Basic LLM Chain` node (currently supports OpenRouter) * Change output fields to match your data structure (adjust the prompt and Google Sheet headers) * Add trigger nodes (e.g., Dropbox Upload, Webhook) to automate input --- ## About Typhoon OCR [Typhoon](https://docs.opentyphoon.ai/en/) is a multilingual LLM and toolkit optimized for Thai NLP. It includes `typhoon-ocr`, a Python OCR library designed for Thai-centric documents. It is open-source, highly accurate, and works well in automation pipelines. Perfect for government paperwork, PDF reports, and multilingual documents in Southeast Asia. ---
n8n$4.99Automate Video Uploads to YouTube and LinkedIn from Google Sheets
Streamline your content distribution by automatically uploading new videos to YouTube and LinkedIn using links from Google Sheets. Enhance your online presence and ensure timely engagement with your audience.
Make$4.99Automate Daily Task Reminders with Google Sheets and Gmail
Streamline your team's productivity by automatically sending personalized task reminders via email for tasks due today using Google Sheets and Gmail.
n8n$4.99Streamline Resume Screening with AI and Google Sheets
Automate the resume review process by integrating AI-driven data extraction and Google Sheets for efficient candidate evaluation and tracking.
n8n$14.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