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"

Sync real-time NFT data from OpenSea to your spreadsheet

This template fetches OpenSea collection or asset data and stores a snapshot in Latenode Database. A webhook supplies the collection slug or contract. JavaScript calls the OpenSea API. Latenode Database writes the record. Telegram sends a short summary. Connect Telegram. Put the OpenSea API key in that JavaScript node.

13s$0.0008

Automate Google News article link extraction and decoding

This template watches a Google News RSS feed and, when a new RSS item arrives, reads the wrapped article URL, decodes it to the publisher link with an HTTP request and JavaScript, and appends title, source, and clean URL to Google Sheets. Paste the Google News feed URL on the RSS trigger. Connect Google Sheets. Put any decode headers you need on that HTTP request node.

13s$0.0008

Automate creation & publication of SEO-optimized WordPress posts from Google Sheets

This template turns a planner row into a WordPress.com draft. A new Google Sheets row supplies topic, keywords, and audience. ChatGPT writes title, excerpt, slug, and HTML. JavaScript assembles the post. Image generation creates a featured image. WordPress.com creates the draft, uploads the image, and attaches it. Google Sheets writes the post URL back on the same row. Connect Google Sheets and WordPress.com, then add a topic row to run it.

1m 4s$0.0040

Automate data analysis with an AI-powered chatbot assistant

This template answers data questions from a chat UI. A webhook receives the message. Google Sheets loads the table you analyze. JavaScript filters and totals the rows that match. ChatGPT writes a short answer from that slice. Supabase stores the question and answer, then the webhook returns the reply. Connect Google Sheets and Supabase. ChatGPT is a Latenode AI step. You do not add an OpenAI key.

35s$0.0022

Automate WordPress publishing with AI-powered research and content creation

This template turns a planner row into a WordPress.com post. A new Google Sheets row supplies the topic. Perplexity gathers sources. ChatGPT writes an SEO title, excerpt, and HTML body. JavaScript assembles the post. Google Docs and a Drive folder store a backup. WordPress.com publishes. Google Sheets writes the live URL back to the planner. Connect Google and WordPress.com, then add a topic row to run it.

1m 56s$0.0074

Automate YouTube Shorts creation, optimization, and publication

This template watches your YouTube channel for a new video, reads the captions, and asks ChatGPT for a short-form script, title, and description. JavaScript turns that script into a vertical-video prompt. Sora renders the moving clip, YouTube uploads it with the ChatGPT metadata, and Google Sheets logs the row. Connect YouTube and Google Sheets. ChatGPT and Sora are Latenode AI nodes. ChatGPT writes the words; Sora renders the video.

24s$0.0015

Publish WordPress blog posts directly from Google Sheets

This template turns a planner row into a WordPress.com post. A new Google Sheets row supplies the topic and writing prompt. ChatGPT writes title, excerpt, and HTML. JavaScript assembles the post. WordPress.com creates it, then Google Sheets writes the post URL back on the same row. Connect Google Sheets and WordPress.com. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key.

23s$0.0014

Sync sports betting odds from The Odds API to your Google Sheets

This template loads sports odds from The Odds API into Airtable and Google Sheets. A schedule runs twice daily. JavaScript calls The Odds API with a key stored in that node: morning runs write upcoming events and odds; evening runs write scores onto the same records. Airtable is the upsert hub; Google Sheets holds the spreadsheet view.

12s$0.0008

Automate keyword research and search volume data in Google Sheets

This template starts when you add a seed keyword to Google Sheets. JavaScript calls the Google Ads Keyword Planner API for related keywords, monthly search volume, competition, and bid estimates, then appends those rows to your research sheet. Put the Google Ads developer token and customer ID in that JavaScript node. Connect Google Sheets and point the trigger at the seed worksheet.

7s$0.0004

Automatically sync Google Analytics data to a Google Sheets report

This template runs on a weekly schedule, asks Google Analytics for page engagement, search, and country metrics for this week and the week before, and uses JavaScript to line those numbers up. Google Sheets stores the rows. Gmail sends the same summary to the address you choose. Connect Google Analytics, Google Sheets, and Gmail, then pick the property and the spreadsheet.

32s$0.0020

Automate lead generation from Google Maps business listings

This template runs on a schedule, reads ZIP codes and business categories from Google Sheets, searches Google Maps with Outscraper for each pair, then writes name, address, phone, and website into a results sheet after JavaScript drops duplicate place ids. Connect Outscraper and Google Sheets. Put the Outscraper API key on the Outscraper connection.

23s$0.0014

Automate scraping business emails from Google Maps to Google Sheets

This template runs on a schedule, searches Google Maps with Outscraper for the query you set, finds emails and contacts for those places, then writes name, domain, and email into Google Sheets after JavaScript removes duplicates. Connect Outscraper and Google Sheets. Put the Outscraper API key on the Outscraper connection.

18s$0.0011

Automate invoice data extraction and sync to Google Sheets

This template turns inbound invoice email into spreadsheet rows. Gmail starts the run when a message lands on the invoices label you choose. Latenode downloads the attachment, OCR Space reads the text, and ChatGPT returns invoice number, supplier, and totals. Google Sheets appends the row, then Gmail labels the message as processed. Connect Gmail, OCR Space, and Google Sheets. Put the OCR Space API key on the OCR Space connection.

3s$0.0002

Automatically sync website email contacts to Google Sheets or a database

This template starts when a webhook receives a website URL. Website Contacts Scraper pulls emails from that page. JavaScript normalizes the addresses and drops duplicates. Each unique email is written as a Google Sheets row and as a Latenode Database object. The webhook then returns the clean list. Connect Google Sheets. Point the scraper at the URL from the webhook body.

15s$0.0010

Automatically sync Crunchbase funding rounds to Google Sheets

This template runs every day, fetches recent seed, Series A, and Series B rounds from Crunchbase through the Piloterr API, and writes company, amount, stage, and LinkedIn URL into Google Sheets. Use a JavaScript node to call the Piloterr API. Put the Piloterr API key in that JavaScript node. Connect Google Sheets and point it at the spreadsheet you keep for outreach.

15s$0.0009

Natural language-powered Google Sheets data exploration

This template starts when you POST a question and a spreadsheet id to a Latenode webhook. Google Sheets reads the tab, JavaScript builds a prompt from those rows, and ChatGPT answers in plain language. Connect Google Sheets. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key.

27s$0.0017

Automatically sync public CSV data to a designated Google Sheets tab

This template downloads a public CSV from a URL you set, parses the rows in JavaScript, and writes them to a Google Sheets tab. Use a schedule so the sheet stays current. Connect Google Sheets and paste the CSV URL on the HTTP request. Filter in JavaScript if you only want some rows.

9s$0.0006

Effortlessly store & manage tweets in Google Sheets

This template runs on the schedule you set, picks a topic or hashtag from the list you keep in JavaScript, asks ChatGPT for a short post, and writes the topic and text into Google Sheets. Connect Google Sheets. ChatGPT is a Latenode AI node, so you do not paste an OpenAI key. Point the sheet at the worksheet that should hold drafts.

17s$0.0011

FX rates to spreadsheet

This template runs on a schedule, fetches JSON from the public Frankfurter and open.er-api endpoints in JavaScript, merges quotes, and writes a dated snapshot as a new row in Google Sheets. Those FX endpoints do not need an API key unless you switch to a paid provider. Connect Google Sheets and set the interval and timezone on the schedule.

7s$0.0004

Automatically capture leads from website, sync to CRM or Sheets, notify team in Slack

This template receives a website lead on a Latenode webhook, creates or updates the HubSpot contact, appends a row in Google Sheets, and posts name and email to a Slack channel. Paste the webhook URL into your form or site. Connect HubSpot, Google Sheets, and Slack, then map email, name, and message on those steps.

24s$0.0015

Sync Google Calendar events to Google Sheets with Slack notifications

This template starts when a Google Calendar event is created or changed, formats title, time, and attendees in JavaScript, appends a Google Sheets row, and posts a Slack message. Use it so the team sees new and updated meetings without opening the calendar. Connect Google Calendar, Google Sheets, and Slack. Point the trigger at the calendar you track and the Slack channel that should get alerts.

39s$0.0025

Automate Udemy course price tracking and get Telegram alerts

This template runs on a schedule, opens Udemy search in an Airtop browser session, and reads title, current price, original price, URL, instructor, and rating. JavaScript keeps courses discounted by 50% or more, Google Sheets logs each deal, and Telegram sends a short alert. Connect Airtop, Google Sheets, and Telegram. Put the Airtop API key on the Airtop connection.

21s$0.0014

Scrape competitors' affiliate data, analyze threats, sync to Sheets & Slack

This template runs twice a day, opens the affiliate URLs you list, scores each competitor from the commercial terms on the page, and writes a row to Google Sheets. High-threat rows post to Slack; you can also email a short digest. Connect Google Sheets, Slack, and Gmail, then put the competitor URLs in the headless-browser start list.

21s$0.0013
Beginner

SERP collection to Sheets

Use Headless Browser to run a Google query page you are allowed to automate, extract result titles/links/snippets in JavaScript, and archive them in Google Sheets. This is not a substitute for official Search APIs when you need scale—document your compliance with Google’s terms.

9s$0.0006