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.
Enrich LinkedIn Profiles from Google Sheets via RapidAPI
### LinkedIn Profile Enrichment Workflow #### Who is this for? This workflow is ideal for recruiters, sales professionals, and marketing teams who need to enrich LinkedIn profiles with additional data for lead generation, talent sourcing, or market research. #### What problem is this workflow solving? Manually gathering detailed LinkedIn profile information can be time-consuming and prone to errors. This workflow automates the process of enriching profile data from LinkedIn, saving time and ensuring accuracy. #### What this workflow does 1. **Input**: Reads LinkedIn profile URLs from a Google Sheet. 2. **Validation**: Filters out already enriched profiles to avoid redundant processing. 3. **Data Enrichment**: Uses RapidAPI's Fresh LinkedIn Profile Data API to retrieve detailed profile information. 4. **Output**: Updates the Google Sheet with enriched profile data, appending new information efficiently. #### Setup 1. **Google Sheet**: Create a sheet with a column named `linkedin_url` and populate it with the profile URLs to enrich. 2. **RapidAPI Account**: Sign up at [RapidAPI](https://rapidapi.com) and subscribe to the Fresh LinkedIn Profile Data API. 3. **API Integration**: Replace the `x-rapidapi-key` and `x-rapidapi-host` values with your credentials from RapidAPI. 4. **Run the Workflow**: Trigger the workflow and monitor the updates to your Google Sheet. #### How to customize this workflow * **Filter Criteria**: Modify the filter step to include additional conditions for processing profiles. * **API Configuration**: Adjust API parameters to retrieve specific fields or extend usage. * **Output Format**: Customize how the enriched data is appended to the Google Sheet (e.g., format, column mappings). * **Error Handling**: Add steps to handle API rate limits or missing data for smoother automation. This workflow streamlines LinkedIn profile enrichment, making it faster and more effective for data-driven decision-making.
n8n$9.99Automate AI-Driven Reddit Engagement with Google Sheets Tracking
This workflow automates Reddit engagement by monitoring posts, analyzing content with OpenAI, and responding intelligently. It tracks interactions in Google Sheets for transparency and ensures relevance and value in community participation.
n8n$14.99Automate Multi-Period Financial Reporting with AI from Google Sheets
This workflow automates the generation of financial reports by comparing revenue and expenses across different periods using data from Google Sheets. It leverages AI for in-depth analysis and summarization, providing valuable insights for business reporting.
n8n$14.99AI Sales Agent: Telegram Approvals & Google Sheets Sync
AI-powered Telegram chatbot for sales/orders with payment approvals and Google Sheets sync. Handles conversations, verification, and tracking with human oversight.
n8n$24.99Automate LINE Chatbot Responses with Google Sheets and Google Gemini AI
This workflow automates AI-assisted replies for LINE Official Account messages, using Google Sheets to store and reference chat history, ensuring contextual and personalized interactions.
n8n$14.99Create Personal Data Vector Store from Google Sheets with OpenAI & Gemini AI
This workflow integrates **Google Sheets** with **Supabase Vector Store** for storing personal data as vectors. It utilizes **OpenAI** and **Google Gemini** AI models for enhanced data processing and querying. The workflow performs the following tasks: - **Extracts personal data** from Google Sheets. - Processes the data using **AI tools** like OpenAI and Google Gemini for intelligent insights. - **Inserts the data** into **Supabase** as vectors, enabling efficient storage and fast querying. - Includes seamless integration with **Postgres** for memory management. - Supports data **loading**, **embedding**, and **management**. This template is ideal for: - Personal data storage with AI-driven **querying** and **analysis**. - Building **intelligent agents** that interact with your data. - Efficient vector-based storage for **personal information**. Perfect for those looking to integrate AI into their personal data workflows.
n8n$9.99Automate Video Transcription and Blog Research with AI and Google Sheets
This workflow automates the process of converting uploaded videos into structured blog research. It transcribes videos, extracts keywords, performs competitor research, and organizes the findings in Google Sheets using Dumpling AI and OpenAI.
n8n$9.99Schedule Food Photo Sharing to Pinterest with GPT-3.5 Captions and Google Sheets
In this guide, we'll walk you through setting up an AI-driven workflow that automatically processes highly-rated food photos from a Google Sheet, generates AI-powered captions, shares them to Pinterest, and updates the sheet to reflect the posts. Ready to automate your food photo sharing? Let's dive in! ## What's the Goal? - Automatically detect and process highly-rated food photos (4 stars or above) from a Google Sheet. - Use AI to generate engaging and relevant captions. - Share the photos with captions to Pinterest via the Pinterest API. - Update the Google Sheet to mark photos as posted. - Enable scheduled automation for consistent posting. By the end, you'll have a self-running system that shares your best food photos effortlessly. ## Why Does It Matter? Manual photo sharing is time-consuming and inconsistent. Here's why this workflow is a game changer: - **Zero Human Error**: AI ensures consistent captions and posting accuracy. - **Time-Saving Automation**: Automatically handle photo sharing, boosting efficiency. - **Scheduled Posting**: Maintain a regular presence on Pinterest without manual effort. - **Focus on Creativity**: Free your team from repetitive posting tasks. Think of it as your tireless social media assistant that keeps your Pinterest feed vibrant. ## How It Works Here's the step-by-step magic behind the automation: ### Step 1: Trigger the Workflow - Detect new photos to post using the Daily Post Scheduler node (e.g., once daily). - Initiate the workflow at a scheduled time to check for new food photos. ### Step 2: Fetch Food Photos from Sheet - Retrieve rows from the Google Sheet that contain food photo metadata like image URLs, ratings, and status. ### Step 3: Filter 4+ Star Dishes - Filter only those food entries with high ratings (4 stars or above) and unposted status. ### Step 4: AI Caption Generator - Use AI (e.g., GPT/OpenAI) to create engaging and relevant captions for selected food photos. ### Step 5: Upload to Pinterest - Automatically post the food photo with the generated caption to Pinterest via the Pinterest API. ### Step 6: Mark as Posted in Sheet - Update the Google Sheet to reflect that the photo has been successfully shared. ## How to Use the Workflow? Importing a workflow in n8n is a straightforward process that allows you to use pre-built workflows to save time. Below is a step-by-step guide to importing the Automated Food Photo Sharing workflow in n8n. ### Steps to Import a Workflow in n8n 1. **Obtain the Workflow JSON** - **Source the Workflow**: Workflows are shared as JSON files or code snippets, e.g., from the n8n community, a colleague, or exported from another n8n instance. - **Format**: Ensure you have the workflow in JSON format, either as a file (e.g., workflow.json) or copied text. 2. **Access the n8n Workflow Editor** - Log in to n8n (via n8n Cloud or self-hosted instance). - Navigate to the Workflows tab in the n8n dashboard. - Click Add Workflow to create a blank workflow. 3. **Import the Workflow** - **Option 1: Import via JSON Code (Clipboard)**: - Click the three dots in the top-right corner to open the menu. - Select Import from Clipboard. - Paste the JSON code into the text box. - Click Import to load the workflow. - **Option 2: Import via JSON File**: - Click the three dots in the top-right corner. - Select Import from File. - Choose the .json file from your computer. - Click Open to import. ### Setup Notes - **Google Sheet Columns**: Ensure your Google Sheet includes the following columns: `Image URL`, `Rating` (numeric, e.g., 1-5), `Feedback` (text), `Pin Title`, `Pin Description`, `Destination URL`, `Board ID`, and `Status` (e.g., Pending or Posted). - **Google Sheets Credentials**: Configure OAuth2 settings in the Fetch Food Photos node with your Google Sheet ID and credentials. - **AI Model**: Set up the AI Caption Generator node with OpenAI credentials (e.g., API key). - **Pinterest API**: Authorize the Upload to Pinterest node with Pinterest API credentials (e.g., Bearer token) and obtain the Board ID. - **Scheduling**: Adjust the Daily Post Scheduler node to your preferred posting time (e.g., daily at 9 AM).
n8n$9.99Automate Fiverr UGC Gig Tracking with Google Sheets
This n8n workflow automates the process of monitoring Fiverr User-Generated Content (UGC) gigs by scraping, parsing, and logging data into Google Sheets. It provides continuous market insights and historical data preservation.
n8n$4.99Topic to LinkedIn, X & Instagram Posts in Google Sheets | Gemini AI Social Media Generator
Creating content for every social network takes time, and each platform has its own rules. This Make scenario does the work for you: add a topic to your Google Sheet, set the status to "To generate", and get three ready-to-publish posts in seconds, each adapted to its platform. For every topic, you get: - A LinkedIn post (150-250 words) with a strong hook, short paragraphs and 3-5 hashtags - An X post (280 characters max) that is punchy, with up to 2 hashtags - An Instagram caption (80-150 words) with a hook, a few emojis and 8-12 hashtags You can set a brand tone and a call to action for each topic. If you add a call to action, it is included naturally in every post. If you leave it blank, each post ends with an engaging question to boost comments. Note: this scenario generates the posts in your Google Sheet so you can review them before publishing. It does not publish automatically to social networks. HOW IT WORKS 1. Add a topic, language and target audience to your Google Sheet. Brand tone and call to action are optional. 2. Set the status to "To generate". 3. The scenario sends your brief to Google Gemini, which writes the three posts. 4. Your sheet is updated with the LinkedIn post, X post, Instagram caption, status and date. If something goes wrong, the row is marked "Error" and the scenario moves on to the next one, so one failed row never blocks the rest. WHAT'S INCLUDED - The Make blueprint (JSON), ready to import REQUIREMENTS - A Make account (the free plan works for testing) - A Google account (Google Sheets) - A Google Gemini API key (free tier available at Google AI Studio) GOOGLE SHEET STRUCTURE Create a Google Sheet with these headers in row 1, in this exact order. The scenario reads and writes by column position, so the order matters more than the names. - Column A: Topic (filled by you) - Column B: Language (filled by you) - Column C: Target audience (filled by you) - Column D: Brand tone (optional) (filled by you) - Column E: Call to action (optional) (filled by you) - Column F: Status (you enter "To generate", the scenario sets "Generated" or "Error") - Column G: LinkedIn post (filled by the scenario) - Column H: X post (filled by the scenario) - Column I: Instagram caption (filled by the scenario) - Column J: Generated at (filled by the scenario) SETUP (ABOUT 5 MINUTES) 1. Create your Google Sheet with the headers above. 2. Import the blueprint into Make (Create a new scenario > ... > Import Blueprint). 3. Connect your Google account in the Google Sheets modules, then select your sheet. 4. Open the "Generate posts with Gemini" module and replace PASTE_YOUR_GEMINI_API_KEY_HERE with your API key. 5. Add a test row, set its status to "To generate", and run the scenario once. Then schedule it. GOOD TO KNOW - Posts can be written in any language: just enter it in the Language column. - Processes up to 10 rows per run (adjustable in the first module). - The status must be exactly "To generate" (case-sensitive). Adding a dropdown in column F helps avoid typos. - For easier reading, enable text wrapping on columns G to I (Format > Wrapping > Wrap). - Avoid double quotes (") in your sheet cells, as they can break the request sent to Gemini.
MakeFreeTopic to Full SEO Blog Article in Google Docs | Gemini AI + Google Sheets
Writing blog content takes hours. This Make scenario does it for you: add a topic to your Google Sheet, set the status to "To write", and get a fully structured, ready-to-edit article in your Google Drive within a minute. Each article includes an H1 title, a clear H2/H3 structure, an engaging introduction, natural keyword integration, a FAQ section with 4-5 common questions, and a conclusion with a call to action. The scenario also writes the final title, an SEO-friendly slug and a meta description (150 characters max) back into your sheet, along with a direct link to the Google Doc. HOW IT WORKS 1. Add a topic, language and target audience to your Google Sheet. Keywords are optional: if you leave them blank, the AI picks the most relevant ones. 2. Set the status to "To write". 3. The scenario sends your brief to Google Gemini, which writes the full article. 4. A Google Doc is created in the folder of your choice. 5. Your sheet is updated with the status, Doc link, final title, slug, meta description and date. If something goes wrong, the row is marked "Error" and the scenario moves on to the next one, so one failed row never blocks the rest. WHAT'S INCLUDED - The Make blueprint (JSON), ready to import REQUIREMENTS - A Make account (the free plan works for testing) - A Google account (Sheets, Docs, Drive) - A Google Gemini API key (free tier available at Google AI Studio) GOOGLE SHEET STRUCTURE Create a Google Sheet with these headers in row 1, in this exact order. The scenario reads and writes by column position, so the order matters more than the names. - Column A: Topic (filled by you) - Column B: Language (filled by you) - Column C: Target audience (filled by you) - Column D: Keywords (optional) (filled by you) - Column E: Status (you enter "To write", the scenario sets "Written" or "Error") - Column F: Doc URL (filled by the scenario) - Column G: Final title (filled by the scenario) - Column H: Slug (filled by the scenario) - Column I: Meta description (filled by the scenario) - Column J: Written at (filled by the scenario) SETUP (ABOUT 10 MINUTES) 1. Create your Google Sheet with the headers above. 2. Import the blueprint into Make (Create a new scenario > ... > Import Blueprint). 3. Connect your Google account in the Google Sheets and Google Docs modules, then select your sheet and Drive folder. 4. Open the "Generate article with Gemini" module and replace PASTE_YOUR_GEMINI_API_KEY_HERE with your API key. 5. Add a test row, set its status to "To write", and run the scenario once. Then schedule it. GOOD TO KNOW - Articles can be written in any language: just enter it in the Language column. - Processes up to 5 rows per run (adjustable in the first module). - The status must be exactly "To write" (case-sensitive). Adding a dropdown in column E helps avoid typos. - Avoid double quotes (") in your sheet cells, as they can break the request sent to Gemini.
MakeFreeAutomate Google Business Profile Posts with GPT-4 and Google Sheets
This powerful n8n workflow automatically generates and publishes Google Business Profile (GMB) posts using topics listed in a Google Sheet. It uses **OpenAI** to write SEO-optimized post descriptions and generate **AI images** based on the topic, then posts them directly to your **GMB profile** and marks them as published in the sheet. --- ## Use Case Perfect for: - Digital marketers managing local SEO - Agencies automating content for clients - Businesses regularly posting to GMB - Teams managing editorial calendars via Google Sheets --- ## Workflow Overview | Node | Purpose | |-------------------------------|------------| | **Schedule Trigger** | Runs daily at 9AM (configurable) | | **Get Unpublished Row** | Reads a row from Google Sheet where Status is not marked Published | | **Generate Post Text** | Uses OpenAI (GPT-4) to write a compelling, local-business optimized post | | **Generate Post Image** | Uses DALL·E or similar to create an image matching the topic | | **Post to GMB** | Publishes the generated content to your Google Business Profile | | **Update Sheet** | Marks the status as Published in the Google Sheet | --- ## Google Sheet Format | Column Name | Description | |-------------|-------------| | Topic | The subject or idea for the GMB post | | Status | Should be blank or Unpublished to trigger the flow | | Date | (Optional) Posting schedule or note | | Notes | (Optional) Internal info - not used in the automation | --- ## Google My Business API Setup ### 1. Google Cloud Configuration - Go to [Google Cloud Console](https://console.cloud.google.com/) - Enable the **Google My Business API** - Create **OAuth2 Client ID** and **Client Secret** - Add this required scope: ``` ### 2. Request for GMB Quota - You need to request for GMB (Google Business Profile) API Quota from here, because by default it sets to zero: https://support.google.com/business/contact/api_default ``` ### 3. n8n Credential Setup - In n8n, go to **Credentials > Google OAuth2** - Use your **Client ID** and **Client Secret** - Use this credential in GMB-related nodes --- ## OpenAI Prompt Customization Modify the prompt in the OpenAI node to match your brand's voice: ### Example Prompt ```text Write a short, engaging Google Business Post about: {{ $json.topic }}. Make it suitable for a local audience and include a subtle call to action. ``` --- ## Optional Enhancements - Add **If** node to delay publishing on certain days - Use **Slack or Email** notifications to alert before/after posting - Use **Multiple Businesses** by adding a Router or Switch node per GMB account --- ## Benefits - Fully automated GMB posting - SEO-optimized, AI-written content - Matching images for visual engagement - Maintains a content log via Google Sheets - Easily customizable prompt logic and schedule
n8n$4.99Streamline Facebook Lead Management with Google Sheets and Team Notifications
This Zap automates the capture of leads from Facebook Lead Ads, organizes them in Google Sheets, and notifies your team via Gmail and Slack, enhancing efficiency and response times.
Zapier$2.99Automate Lead Updates from Google Sheets to Discord Notifications
Streamline your lead management by automatically updating lead information in Google Sheets and notifying your team via Discord.
ZapierFreeAutomate Smartlead Email Campaign Analytics with Google Sheets
This workflow automates the collection of email campaign analytics from Smartlead and updates Google Sheets for real-time insights. It ensures you have up-to-date domain and email health metrics, as well as campaign-specific performance data.
n8n$14.99AI Sales Agent for Telegram with Google Sheets Integration
Automate your sales process using a Telegram bot and sync with Google Sheets for efficient order management.
n8n$19.99Streamline Lead Management from Website Forms to Google Sheets and Slack
Effortlessly capture and manage leads by automating the process from website form submissions to Google Sheets and Slack notifications. This workflow ensures your team is instantly informed of new inquiries and maintains an organized lead database.
n8n$4.99Automate Meeting Attendee Data Enrichment with Apollo.io and Google Sheets
Streamline your meeting preparation by automatically enriching attendee profiles with Apollo.io data and logging it into Google Sheets. Perfect for sales, customer success, and recruitment professionals.
n8n$9.99Extract Business Data from Google Maps via Chat to Excel and Google Sheets
## Who is this for This workflow is designed for marketers, researchers, and business owners who need to quickly find and export company data from Google Maps into a structured table format. ## What problem is this workflow solving Manually collecting business contact information from Google Maps is time-consuming and error-prone. This workflow automates the process, allowing users to instantly extract company data and export it to Excel or Google Sheets for further use. For example, title, rating, reviews, address, operating hours, phone, website, type, GPS coordinates. ## What this workflow does - Takes a user's search query via chat - Scrapes company data from Google Maps based on that query - Returns the results in a downloadable Excel file - Saves the same data to a connected Google Sheets document for easy access and sharing ## Setup 1. Add your credentials: - Google Sheets API - Google Maps API 2. Run the workflow and enter your search request in the chat interface 3. Retrieve your results from either: - The Get XLSX node as an Excel file - The linked Google Sheets file
n8n$9.99Automate Lead Enrichment from Google Sheets to HubSpot with Surfe
Streamline your lead enrichment process by automatically enriching contact data from Google Sheets using Surfe and updating HubSpot CRM.
n8n$9.99Track Expenses by Parsing Telegram Transaction Messages to Google Sheets
**Overview** This n8n workflow template automatically parses incoming Telegram transaction messages and logs structured data into a Google Sheet. It's designed to help individuals and small businesses track and record transactions shared via Telegram without manual data entry. **Target Audience** This template is ideal for: - Individuals, freelancers, and small businesses who receive transaction or payment notifications through Telegram and want to organize them in Google Sheets. - Anyone using self-hosted n8n (required due to custom community nodes). **Problem Solved** Manually copying transaction details from Telegram to Google Sheets is error-prone and time-consuming. This workflow automates the process by: - Monitoring a Telegram bot/chat for new messages. - Parsing transaction details (amount, sender, date, etc.). - Logging them in real-time into a Google Sheet for easy tracking. **Setup Instructions** 1. **Telegram Bot Setup** - Create a Telegram bot using BotFather. - Add the bot to the desired group/channel and grant admin permissions if needed. - Note down the bot token. 2. **Google Sheets Setup** - Create a Google Sheet with relevant columns (e.g., Date, Amount, Sender, Transaction ID). - Set up Google Sheets credentials in n8n for access. 3. **n8n Workflow Configuration** - Import this template into your self-hosted n8n instance. - Update the Telegram node: Add your bot token and specify the chat/group ID. - Update the Google Sheets node: Link it to your created sheet and ensure column mapping matches your sheet structure. - Adjust parsing logic if your message format varies (see next section for examples). 4. **Community Nodes** - This workflow uses custom community nodes. Ensure these are installed via the n8n settings or CLI: - [List your required community nodes here, e.g., n8n-nodes-telegram, n8n-nodes-gsheet, etc.] 5. **Activate the Workflow** - Save and activate your workflow. Send a test transaction message to your Telegram group/chat and verify data appears in your Google Sheet. 6. **Troubleshooting** - If messages are not being picked up, check bot permissions and the chat ID. - Ensure Google Sheets credentials are correct and the sheet is accessible. - Double-check that custom nodes are properly installed and up-to-date. **Example Telegram Message Formats** - Received: $75 from @john_doe on 2024-05-29. Transaction ID: 12345XYZ. - Paid $120 to @vendor on 2024-05-28. Ref: 67890ABC. - You received ₹5,000 from @amit. ID: 54321PQR. Date: 29/05/2024 The workflow parses messages in the above formats and logs the following columns: - Date - Amount - Sender/Receiver - Transaction/Reference ID If your message format differs, update the regex in the parsing node. **Disclaimer** This n8n workflow template uses custom community nodes and is only compatible with the self-hosted version of n8n. **Workflow Changes (For n8n Canvas)** Rename the Nodes: - If node → "Is Transaction Message?" - Google Sheets node → "Log to Google Sheet" (Rename other generic nodes for clarity, e.g., Telegram → "Listen for Telegram Messages", Function → "Parse Transaction Details") Sticky Note Improvement: (Edit the sticky note or add one if missing) **Workflow Steps:** - Listen for Telegram Messages: This node receives new messages from the Telegram bot. - Is Transaction Message? Checks if the message matches known transaction patterns. - Parse Transaction Details: Extracts amount, sender, date, and transaction ID using regex. - Log to Google Sheet: Records the parsed transaction in the linked Google Sheet for easy tracking.
n8n$4.99Automatically Flag Bounced Emails in Google Sheets from Gmail
This workflow scans your Gmail inbox for delivery error messages and flags the associated email addresses in a Google Sheet, ensuring future campaigns skip these addresses.
n8n$14.99Automate Multi-Step Email Campaigns with Gmail and Google Sheets
Streamline your email marketing by automating multi-step campaigns using n8n, Gmail, and Google Sheets. This workflow sends initial and follow-up emails based on recipient responses, ensuring efficient communication management.
n8n$24.99Extract Pay Slip Data with LINE Chatbot and Geminio to Google Sheets
## Workflow Overview: Extracting text from an image using AI is worthwhile because it requires no code. It incorporates the Google Gemini 2.0 Flash model for important text extraction from images. If you code without AI, you have to use multiple conditions and may cause a lot of bugs, but with Google Gemini, you don't need any coding, and if the Pay Slip is different, Gemini will extract it automatically. ## Workflow Description: 1. The user uses the Line Messaging API to send a Pay Slip image or message to the chatbot. Create a Line Business ID from here: [Line Business](https://account.line.biz/login). 2. Classify the message as either an image or text. 3. If the message is a Pay Slip image, it will be processed using Gemini 2.0 Flash EXP and extract important information and respond in JSON format without coding by using the following prompt: Analyze the image and then return in JSON Response that has the only following values: **Status, From, To, Date, Amount**.  To get the Google AI Studio API Key, you can find it from the following link: [Google AI Studio API Key](https://aistudio.google.com/apikey). 4. Create Google Sheets which include the fields **(Status, From, To, Date, Amount)** that we have created related to the AI prompt [Google Sheets](http://docs.google.com/spreadsheets) as the following example:  5. If the message is text, it will process using the Gemini 2.0 Flash EXP model as the AI Assistant; else if the message is an image, it will extract the important fields, then reply to the user and insert into Google Sheets. ## Key Features: * **Extract text from image with No Code** - Without N8N, we have to write code to extract text from an image, but with N8N and Google Gemini 2.0 Flash EXP together, we don't need to code, and it will process all slip vendors or other document vendors. * **Multipurpose Chatbot** - This chatbot accepts both text and image, so we don't have to create many chatbot accounts. * **Reduce human error** - This workflow lets any officer verify document status when the job ends. **Note:** You can change the information by changing your prompt and also Google Sheets Column names relatively.
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