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.
Automate Dialogflow Intent Backup to Google Sheets via Telegram
This workflow automates the export of Dialogflow intents, complete with priority levels, to a Google Sheets document. Triggered by a Telegram message, it provides visual priority indicators for easy analysis.
n8n$9.99Automate YouTube Video URL Collection to Google Sheets
Automatically fetch and organize YouTube video URLs from multiple channels into Google Sheets for streamlined tracking and analysis.
n8n$4.99Automate Strava Data Logging into Google Sheets
This workflow allows users to automatically log their Strava training results into Google Sheets, ensuring that all workout data is captured without manual entry. By connecting Strava and Google Sheets, this automation saves time and reduces the p...
Make$12.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.99Automate Brand Story Creation and Optimization with Ollama and Google Sheets
This n8n workflow automates the generation, evaluation, and optimization of brand stories using Ollama-hosted LLMs and LangChain agents, saving finalized stories to Google Sheets.
n8n$9.99Send a ChatGPT Email Reply and Save Responses to Google Sheets
This workflow sends an OpenAI GP reply when an email is received from specific email recipients. It then saves the initial email and the GP response to an automatically generated Google spreadsheet. Subsequent GP responses will be added to the same spreadsheet. Additionally, when feedback is given for any of the GP responses, it will be recorded to the spreadsheet, which can then be used later to fine-tune the GP model. ## Prerequisites - [OpenAI credentials](https://docs.n8n.io/integrations/builtin/credentials/openai/) - [Google credentials](https://docs.n8n.io/integrations/builtin/credentials/google/) ## How it works This workflow is essentially a two-in-one workflow. It triggers off from two different nodes and has very different functionality from each trigger. The flow triggered from the `On email received` node is as follows: 1. Triggers off on the `On email received` node. 2. Extract the email body from the email. 3. Generate a response from the email body using the `OpenAI` node. 4. Reply to the email sender using the `Send reply to recipient` node. A feedback link is also included in the email body which will trigger the `On feedback given` node. This is used to fine-tune the GP model. 5. Save the email body and OpenAI response to a Google Sheet. If a sheet does not exist, it will be created. The flow triggered from the `On feedback given` node is as follows: 1. Triggers off when a feedback link is clicked in the emailed GP response. 2. The feedback, either positive or negative, for that specific GP response is then recorded to the Google Sheet.
n8n$24.99Automate Blog Content Crawling and Storage in Google Sheets Using Dumpling AI
Streamline your content audit process by automatically crawling website blogs and saving the data to Google Sheets. Ideal for content strategists and SEO specialists.
n8n$9.99Automate Company Data Enrichment and Export to Google Sheets
This workflow automates the enrichment of company data using Extruct AI and exports the results to Google Sheets. Ideal for sales and business development professionals looking to stay updated on company news and trends.
n8n$9.99Automate Financial Tracking from Gmail to Google Sheets
This workflow automates the extraction of transaction details from Gmail emails and organizes them into a Google Sheet for streamlined financial tracking.
n8n$14.99Automate LinkedIn Job Listing Scraping and Storage in Google Sheets
This workflow automates the process of scraping LinkedIn job postings for specified companies using Phantombuster and organizes the data into Google Sheets every Monday morning. It streamlines job market research and competitive analysis by providing structured job data without manual intervention.
n8n$9.99Automate Instagram Stats Updates with Mattermost and Google Sheets
This workflow automates the process of sending Instagram statistics to a Mattermost channel using data from Google Sheets.
n8n$12.79Automate GPT-4 Fine-Tuning with Google Sheets or Airtable
Streamline the process of fine-tuning GPT models by automating data extraction from Google Sheets or Airtable, converting it to JSONL, and initiating the fine-tuning process with OpenAI.
n8n$14.99Automate Property Link Shortening & QR Code Generation with Google Sheets and Bitly
### How It Works This workflow automatically takes a long property URL from your Google Sheet, shortens it, generates a QR code, and then updates your sheet with the new links. 1. **Google Sheets (New/Updated Row Trigger):** The workflow starts by constantly monitoring a specified Google Sheet. It triggers when a new property listing row is added, or when an existing row's Property Link column is updated. 2. **Shorten URL (HTTP Request - Bitly):** This node takes the long property URL from the Google Sheet. It then makes an API call to a URL shortening service (like Bitly) to generate a much shorter, shareable URL. 3. **Generate QR Code (HTTP Request - QR Code API):** Using the shortened URL from the previous step, this node makes another API call to a QR code generation service. It generates an image link for a QR code that, when scanned, directs users to your property. 4. **Update Google Sheet (Update Row):** Finally, this node takes the newly generated short URL and the QR code image link and writes them back into the corresponding row in your Google Sheet. This centralizes all the necessary links for your property listings. ### How to Set Up Follow these steps carefully to get your Property Link Shortener & QR Code Generator workflow up and running in n8n: 1. **Import Workflow JSON:** - Open your n8n instance. - Click on Workflows in the left sidebar. - Click the + button or New to create a new workflow. - Click the ... (More Options) icon in the top right. - Select Import from JSON and paste the entire JSON code for this workflow. 2. **Prepare your Google Sheet:** - Create a Google Sheet with columns for your property listings. - **Crucially**, ensure you have a column for the **original long property URL** (e.g., `Property Link`), a column for the **shortened URL** (e.g., `Short URL`), a column for the **QR code image URL** (e.g., `QR Code URL`), and a **unique identifier** for each row (e.g., `Property ID`). 3. **Configure Google Sheets (New/Updated Row Trigger):** - Locate the Google Sheets (New/Updated Row Trigger) node. - **Credentials:** Select your existing Google Sheets OAuth2 credential or click Create New to set one up. - **Spreadsheet ID:** **Replace `YOUR_SPREADSHEET_ID`** with the ID of your Google Sheet. You can find this ID in the Google Sheets URL. - **Sheet Name:** Enter the exact name of the sheet (tab) within your spreadsheet (e.g., `Listings` or `Properties`). - **Trigger On:** Choose `Updated Row` and select the column where your original long property link is located (e.g., `Property Link`). This ensures the workflow runs when you add or update a property link. 4. **Configure Shorten URL (HTTP Request - Bitly):** - Locate the Shorten URL (HTTP Request - Bitly) node. - **Method:** Set to `POST`. - **URL:** `https://api-ssl.bitly.com/v4/shorten` - **Headers:** - Add `Authorization` with value `Bearer YOUR_BITLY_ACCESS_TOKEN`. (You'll need to generate a Generic Access Token from your Bitly account settings > Generic Access Token). - Add `Content-Type` with value `application/json`. - **Body:** Select `Raw` and `JSON`. - In the JSON body, enter: `{long_url: {{ $json["Property Link"] }}}`. **Ensure `Property Link` exactly matches your Google Sheet column header for the original URL.** - **Response Format:** Set to `JSON`. 5. **Configure Generate QR Code (HTTP Request - QR Code API):** - Locate the Generate QR Code (HTTP Request - QR Code API) node. - **Method:** Set to `GET`. - **URL:** `https://api.qrserver.com/v1/create-qr-code/?size=150x150&data={{ encodeURIComponent($(1. Shorten URL (HTTP Request - Bitly)).item.json.link) }}` - Here, `{{ $(1. Shorten URL (HTTP Request - Bitly)).item.json.link }}` refers to the output of the previous Bitly node. - You can adjust `size=150x150` as needed. - `encodeURIComponent` is important to handle special characters in the URL. - **Response Format:** Set to `Binary`. (This API directly returns the image, but we just need its URL which is in the `url` property of the response). 6. **Configure Update Google Sheet (Update Row):** - Locate the Update Google Sheet (Update Row) node. - **Credentials:** Select the same Google Sheets OAuth2 credential as in step 3. - **Spreadsheet ID:** Use the same `YOUR_SPREADSHEET_ID`. - **Sheet Name:** Use the same `YOUR_SHEET_NAME_E.G._Listings`. - **Key Column:** Set this to a unique identifier for your rows, e.g., `Property ID` (assuming you have one in your sheet). - **Key Column Value:** `={{ $json["Property ID"] }}`. **Make sure this matches your unique ID column from the Google Sheet.** - **Update Columns:** - Add an entry: - **Column:** `Short URL` (exact name of your short URL column in Google Sheet)
n8n$4.99Automated Prescription Management Workflow with Google Sheets
Streamline your prescription management process using this automated n8n workflow with Google Sheets integration.
n8n$19.99Automate OpenAI API Usage and Cost Tracking with Google Sheets
Effortlessly track OpenAI API usage and costs by automatically logging detailed metrics into a Google Sheets template. This workflow helps teams analyze and manage expenses effectively.
n8n$19.99Automate Face Swapping in GIFs Using AI with Google Sheets and Google Drive
Effortlessly swap faces in GIFs using AI by integrating Google Sheets for input and Google Drive for output. This workflow automates the process, making it ideal for content creators and marketers.
n8n$14.99Automate Google Sheets Data Retrieval with AI Integration
This workflow automates the process of fetching data from Google Sheets using an AI agent, enhancing efficiency and data handling.
n8n$6.77Automate Meeting Minutes Distribution with Google Sheets & Gmail
Automates sending meeting minutes via Gmail whenever a new row is added to a Google Sheet. Simplifies sharing notes with teams, saving time on manual distribution.
n8n$12.99LINE BOT - Google Sheets Record Receipt Automation
This workflow automates the capture and recording of receipt images sent via LINE messaging into Google Sheets. By utilizing a webhook, the workflow triggers upon receiving a message, retrieves the associated image, and prepares the data for uploa...
n8n$14.99Automate Twitter Sentiment Analysis with OpenAI, Google Sheets, and Slack Alerts
This workflow automates the monitoring of Twitter mentions, performs sentiment analysis using OpenAI, logs data in Google Sheets, and sends Slack alerts for negative tweets. It streamlines brand reputation management by eliminating manual monitoring.
n8n$9.99Automate Email Categorization and Tracking with AI and Google Sheets
Automatically categorize and track company emails using AI and update Google Sheets with categorized data for efficient request management.
n8n$9.99Automate Personalized Email Campaigns Using Google Sheets and Gmail
Streamline your email outreach by automating personalized email campaigns directly from Google Sheets using n8n and Gmail. Ideal for marketers, recruiters, and small business owners.
n8n$4.99Automate Data Insertion and Retrieval in Google Sheets
This workflow automates the process of inserting and retrieving data from Google Sheets, streamlining data management tasks.
n8n$4.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.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