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.
Automate Endpoint Risk Assessment with EDR and Google Sheets
Automatically assess and prioritize endpoint risks by integrating EDR logs, vulnerability data, and asset inventories using Google Sheets. Ideal for security teams aiming to streamline their risk management processes.
n8n$9.99Filter and add new rows in Google Sheets while clearing outdated data
Automatically filter and add new rows in Google Sheets while clearing outdated data. Streamline data management with this Google Sheets automation.
Make$3.99Build a REST API with Google Sheets as a Database
Create a fully functional REST API using n8n and Google Sheets to manage CRUD operations without writing any code.
n8n$14.99Create new notes in Productboard from new rows in a Google Sheets spreadsheet
This templates periodically retrieves new rows from a Google Sheets spreadsheet and uses the information to create new notes in Productboard. The template is using [this sample](https://docs.google.com/spreadsheets/d/1ZbveKRVt-KocnP744uJ_7h6DJkU1K5Kp0b4Onf9XwB4/edit?usp=sharing) Google Sheets spreadsheet as a data source. You should make a copy of it before configuring the template. The template is scheduled to run every 15 minutes. You can change this after you set up the template.
Make$2.99Lead Enrichment Pipeline: Leadfeeder → Apollo → Google Sheets
Automates daily extraction of yesterday's website visitors from Leadfeeder, enriches with Apollo.io data, deduplicates, updates Google Sheets, and sends Telegram alerts.
n8n$24.99Synchronize WooCommerce Orders with QuickBooks and Google Sheets Inventory
Automatically update inventory levels in QuickBooks and Google Sheets whenever a new order is placed in WooCommerce. This ensures accurate stock management across platforms.
Make$4.99Bulk Verify WhatsApp Numbers via Google Sheets & WasenderAPI
Automates bulk verification of WhatsApp numbers from Google Sheets using WasenderAPI, checking registration status and updating the sheet with results.
n8n$14.99Automate Google Sheets Updates with RSS and OpenAI GPT-3 Insights
Automatically update Google Sheets with new articles from an RSS feed, enriched with content insights generated by OpenAI GPT-3.
Make$3.99Instant Real Estate Lead Response with Gmail and Google Sheets
📋 HOW IT WORKS • Any website form (WordPress, Webflow, Typeform, Jotform, Zapier…) posts the enquiry to the webhook • The lead is normalized (any field names), validated and scored 0-100: phone, timeline, budget, property reference, financing keywords • It is saved in Google Sheets; repeat enquiries update the same row (stable Lead ID) • The lead instantly receives a personalized email for buying, selling (valuation offer) or renting, with your booking link • Hot leads trigger an alert to you; the form receives a JSON answer (invalid posts get HTTP 422) ⚙️ SETUP STEPS • About 10 minutes: create a Google Sheet with a "Leads" tab (columns below), import the workflow, connect Google Sheets and Gmail, fill the Config node (Sheet ID, agency, email, booking link), publish and paste the webhook URL into your form • Requires n8n 2.x (Cloud or self-hosted) and a Google account. No community nodes, no API keys ℹ️ ADDITIONAL INFORMATION • "Leads" tab header row: Lead ID,Last Enquiry At,Name,Email,Phone,Intent,Property Ref,Budget,Timeline,Preferred Areas,Min Bedrooms,Property Type,Message,Source,Score,Temperature,Status,Follow-up Step,Last Contact At,Next Follow-up At,Notes • Sticky-note documentation inside the workflow; email texts and scoring weights are easy to edit in one Code node • No credentials or personal data inside • Tested on n8n 2.41 with an automated test suite and a live run on real Google Sheets and Gmail • Part of the Real Estate Automation Kit (5 workflows) by the same seller
n8n$29SmartLead Sheet Sync: Auto-Capture Client Inquiries to Google Sheets
Automates capturing webform client inquiries via webhook, formats data with code, and logs directly to Google Sheets in real-time.
n8n$9.99Send data from a custom webhook to Google Sheets and update ClickUp tasks with custom fields
Automatically send data from a custom webhook to Google Sheets and update ClickUp tasks with custom fields for streamlined project management.
Make$3.99Send Merci Facteur postcards from new Google Sheets rows
Every time a new row is added to your Google Sheets spreadsheet, Make will automatically send a Merci Facteur postcard for it.
Make$3.99Bulk generate images from Google Sheets with Leonardo.AI and store in Google Drive
Seamlessly automate the bulk creation of images using Leonardo.Ai based on prompts from a Google Sheets list. Once generated, the images are automatically saved to a specified Google Drive folder for easy access and organization.
Make$3.99Add a new contact from a submitted Ontraport form to Google Sheets
Every time a contact is created in Ontraport using an Ontraport form, Make will automatically add the contact to your Google Sheets spreadsheet. The template uses this [Ontraport form](https://danielb.ontralink.email/f/1/229120/1/e825c63e7c702c445203968635c6bce4) and this [Google Sheets spreadsheet](https://docs.google.com/spreadsheets/d/1fRnSB9WMVmIvWMHoFcHWcWJuViCl6LtPc7oinvSQ94/edit?usp=sharing).
Make$3.99Automated Google Sheets Update for LinkedIn Profile Evaluation
This workflow streamlines the process of extracting valuable information from LinkedIn profiles and updating Google Sheets accordingly. By utilizing a manual trigger, users can initiate the workflow at their convenience, ensuring they capture the ...
n8n$14.82Subscription Tracker & Reminders with GPT-4, Telegram & Google Sheets
Automates daily subscription billing reminders via Telegram and AI-powered management of Google Sheets data for adding, updating, or retrieving subscriptions.
n8n$24.99Fetch data from an API and add a new row in Google Sheets
Automatically fetch data from an API and add a new row in Google Sheets. Streamline data management with HTTP and Google Sheets integration.
Make$3.99Capture Typeform Responses in Google Sheets and Get Notified via Email
This Zap automates the process of collecting responses from Typeform, filtering them based on specific criteria, formatting the date and time, adding the relevant information to a Google Sheets spreadsheet, and sending a notification via Gmail. This streamlines data management and communication, ensuring that important entries are tracked and shared efficiently.
Zapier$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.99Generate Taxpayer's Signature Code from Google Sheets and Post to Slack
Automatically create a Taxpayer's Signature Code (PKP) from new rows in a Google Sheets spreadsheet and send the code to a specified Slack channel.
Make$3.99Sync New HubSpot CRM Contacts to Google Sheets
Automatically monitor new contacts in HubSpot CRM and add them as new rows in Google Sheets, keeping your data synchronized and up-to-date.
MakeFreeGet weekly updates in Slack from Google Sheets
This Zap automates the process of scheduling weekly tasks and sending reminders to a Slack channel based on data from Google Sheets. By integrating these tools, users can efficiently manage their weekly activities, ensuring that important tasks are not overlooked and that team members are kept informed in real-time.
Zapier$4.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.99Automate Daily Square Sales Reports into Google Sheets
This workflow automatically retrieves daily sales data from Square and imports it into Google Sheets, matching the Square Dashboard Sales Summary for easy analysis and reporting.
n8n$9.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