Latenode

Automation Templates

Ready-to-use workflow templates for AI agents, browser automation, and messaging integrations. Get started in minutes.

Found 123 templates linked to integration "google-sheets"

Automatically sync Splitwise expenses to Google Sheets

This template watches Splitwise for new expenses, maps description, amount, date, and expense id in JavaScript, and appends a Google Sheets row. Connect Splitwise and Google Sheets, pick the group you care about and the spreadsheet, and keep credentials on those connections. Put the Splitwise key on the Splitwise connection.

10s$0.0006

Sync Phantombuster data to Google Sheets for real-time management

This template starts when a Phantombuster phantom finishes and emits output. Latenode downloads that result, JavaScript maps the fields onto sheet columns, and Google Sheets appends the rows. Use it for leads or scrape results you already collect in a phantom. Connect Phantombuster and Google Sheets, then put the Phantombuster API key on the Phantombuster connection.

9s$0.0006

Automatically sync YouCanBook.Me schedules to Google Sheets

This template starts when YouCanBook.Me records a new booking, then adds a Google Sheets row with the client, time, and custom fields you map. Connect YouCanBook.Me and Google Sheets. Put YouCanBook.Me access on that connection and point Sheets at the worksheet you use as the booking log.

6s$0.0004

Unbounce leads to Google Sheets

This template writes each Unbounce form submit as a Google Sheets row. Unbounce starts the run. JavaScript flattens nested fields into a stable row. Google Sheets appends it. Connect Unbounce and Google Sheets, then choose the page, form, spreadsheet, and worksheet.

7s$0.0004

Automatically sync Facebook Lead Ads data to Google Sheets

This template starts when someone submits a Facebook Lead Ad form, maps name, email, and phone in JavaScript, and appends a Google Sheets row. Fetch full lead details from Facebook if the trigger payload is incomplete. Connect Facebook Lead Ads and Google Sheets, then pick the Page and form you want to watch.

7s$0.0004

Automate personalized SendGrid emails for new Google Sheets rows

This template watches a Google Sheet for new rows, reads name, email, and the columns you map, and sends a personalized message through SendGrid. JavaScript calls the SendGrid mail API. Connect Google Sheets. Put the SendGrid API key in that JavaScript node, then point the trigger at the worksheet that collects contacts.

7s$0.0004

Automatically sync Google Sheets data to generate professional quotes in Google Docs

This template starts when Google Sheets adds a row with quote data. JavaScript maps customer, line items, and totals onto your Docs template placeholders. Google Docs creates the quote from that template and replaces the placeholders. Connect Google Sheets and Google Docs, then point the trigger at the sheet that holds new quotes.

7s$0.0004

Automate Google Ads copywriting across multiple campaigns

This template starts when you add a row in Google Sheets with product, keywords, and landing page. ChatGPT writes headlines and descriptions. JavaScript sends that copy to the Google Ads API, then Sheets stores the copy on the same row. Connect Google Sheets. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key. Put the Google Ads developer token in the JavaScript node.

17s$0.0011

Sync LinkedIn messages to Google Sheets and get real-time Gmail alerts

This template watches Gmail for LinkedIn Sales Navigator message notifications, pulls the sender name in JavaScript, looks that name up in a Google Sheets lead list, and sends a Gmail alert when it matches. It can also append a log row so the team sees who wrote and whether they are a known lead. Connect Gmail and Google Sheets. Filter the Gmail trigger to LinkedIn notification mail or a label you use for those messages.

12s$0.0008

Sync Gmail messages to Zendesk tickets and log in Google Sheets

This template watches Gmail for a new message, maps sender, subject, and body in JavaScript, creates a Zendesk ticket, and appends a log row in Google Sheets. Use it so support mail becomes a ticket and a searchable log in one run. Connect Gmail, Zendesk, and Google Sheets. Point the Gmail trigger at the inbox or label you use for support.

11s$0.0007

Automate news discovery and sharing for your Slack community

This template runs on a morning schedule, reads search topics from Google Sheets, queries Google Programmable Search, and asks ChatGPT for a short summary from the result snippets. It logs title and URL in Sheets and posts the summary to Slack. Connect Google Programmable Search, Google Sheets, and Slack, put the search API key on the Programmable Search connection, and use ChatGPT as a Latenode AI step so you do not paste an OpenAI key.

36s$0.0023

Automatically track keyword rankings in Google Sheets

This template starts when you POST a keyword and country to a Latenode webhook, calls a SERP ranking endpoint over HTTP, and appends the results to Google Sheets. Put the RapidAPI key on that HTTP request. Connect Google Sheets. If the API returns no hits, JavaScript writes a no-result row so the log stays complete.

16s$0.0010

Automatically sync Gmail leads to Google Sheets and notify Slack

This template watches Gmail for a new message, extracts company and email in JavaScript, appends a Google Sheets row, and sends a Slack message. Skip personal domains so the sheet stays business-only. Connect Gmail, Google Sheets, and Slack. Point the Gmail trigger at the inbox or label that holds leads.

13s$0.0008

Telegram-powered AI assistant syncs meals to Google Sheets

This template starts when your Telegram bot receives a meal message. JavaScript treats it as text, a photo, or a voice note. Voice is transcribed with Latenode speech-to-text. ChatGPT extracts the meal, portions, and macros, then Google Sheets appends a row. Telegram sends a short confirmation back. Connect Telegram and Google Sheets. Put the bot token on the Telegram connection. ChatGPT and speech-to-text are Latenode AI steps.

1m 21s$0.0051

Automate keyword difficulty analysis and SERP data in Google Sheets

This template records keyword difficulty and SERP hits in Google Sheets. A form or app posts keyword and country to a Latenode webhook. JavaScript calls the RapidAPI Keyword Difficulty Checker and returns difficulty metrics plus SERP results. Google Sheets appends those rows. Put the RapidAPI key in that JavaScript node. Connect Google Sheets.

10s$0.0006

Sync Google Sheets data with ChatGPT-5 for natural language queries

This template starts when you post a question to a Latenode webhook, reads the connected Google Sheet, and asks ChatGPT to answer from that data. It then appends the question and answer as a new row. Connect Google Sheets and point Get Values at the worksheet you want to query. ChatGPT is a Latenode AI step.

33s$0.0021

Scrape and log your website's on-page SEO metrics to Google Sheets

This template runs on a schedule, reads the URLs you track from Google Sheets, calls an on-page SEO API on RapidAPI from JavaScript, and appends title, meta, headings, and similar metrics as a new row. Connect Google Sheets. Put the RapidAPI key in the JavaScript node that makes the request.

16s$0.0010

Extract contacts from TruePeopleSearch and log to Google Sheets

This template looks up people from a Google Sheet on TruePeopleSearch. A new row starts the run. JavaScript calls the Zyte API, parses name, age, phone, email, and addresses, and updates that row. If the main profile has no phone, the same node fetches relative profiles. Connect Google Sheets. Put the Zyte API key in that JavaScript node.

25s$0.0016

Automatically store & compare website keyword rankings in Google Sheets and get Slack alerts

This template runs once a day, reads the keywords you track from Google Sheets, looks up each query with Serper, and writes the new rank back to the sheet. JavaScript compares that rank to the last stored position and, when the drop is past the threshold you set, posts a Slack message. Connect Google Sheets, Serper, and Slack. Put the Serper API key on the Serper connection.

19s$0.0012

Automated PDF invoice extraction and Telegram reporting

This template watches a Google Drive folder for new invoice files, downloads each file, reads text with OCR Space, and uses JavaScript to pull date, vendor, and total into a Google Sheets row. Telegram then sends a short billing message. Connect Google Drive, OCR Space, Google Sheets, and Telegram. Put the OCR Space API key on the OCR Space connection. Put the Telegram bot token on the Telegram connection.

24s$0.0015

Telegram AI Image Generator with Quota Tracking in Google Sheets

This template listens for Telegram bot messages, checks that user's daily quota in Google Sheets, asks ChatGPT to tighten the prompt, generates a still with OpenAI Image Generation, and sends the photo back in the same chat. Each successful run is logged in the sheet. Put the bot token on the Telegram connection. ChatGPT and image generation are Latenode AI steps, so you do not paste an OpenAI key.

51s$0.0032

Automatically sync Facebook Ads data to a Google Sheets report

This template runs on a schedule, calls the Facebook Marketing API Insights endpoint from JavaScript, and writes campaign metrics to Google Sheets. Use it for a daily spend report without exporting ads data by hand. Connect Google Sheets. Put the Marketing API token in that JavaScript node. Map ad account id, date range, and the sheet columns you want.

12s$0.0008

Scrape and sync Instagram profiles to Google Sheets

This template reads a username list from Google Sheets, runs your Apify Instagram profile actor, and writes cleaned profile fields back to the sheet. A schedule starts each batch. JavaScript maps username, bio, and follower counts, then Google Sheets appends the row and marks the username as done. Connect Apify and Google Sheets. Put the Apify API key on the Apify connection.

13s$0.0008

Automate Google Business Profile posts with AI content & Google Sheets

This template runs on the schedule you set, reads the next unpublished topic from Google Sheets, asks ChatGPT for post copy, generates a still image, and publishes to Google Business Profile. It then marks that row published. Connect Google Sheets and Google Business Profile. ChatGPT and image generation are Latenode AI steps, so you do not paste an OpenAI key.

33s$0.0021