ChatGPT

JavaScript

Google Sheets

Gmail

Automate keyword list generation and sync to Google Sheets

This template starts when you send a topic to a Latenode webhook. ChatGPT returns a keyword list with short insights, JavaScript shapes the rows, Google Sheets stores them, and Gmail emails you the same list. Connect Google Sheets and Gmail. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key.

Updated Sep 16, 2026Est. run: 18sEst. cost: $0.0011

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how CPU seconds work →

Workflow preview

What this template does

Turns a topic into a keyword list without manual research
Writes keywords with ChatGPT
Stores the rows in Google Sheets
Emails the same list with Gmail

How it works

Trigger

Receive the topic

The scenario starts when a form or app POSTs a topic to your webhook.

Generate keywords

ChatGPT returns keywords with intent and a one-line insight for each.

Logic

Shape the rows

JavaScript turns that list into sheet rows.

Action

Save and email

Google Sheets appends the rows. Gmail sends you the same list to review.

Setup guide

Add a webhook trigger

Add a webhook trigger and copy its URL. Point your form at that URL and send a topic field.

Connect Google Sheets and Gmail

Add a Google Sheets connection with a tab for keyword, intent, insight, and topic. Add a Gmail connection for the inbox that should receive the list.

Ask ChatGPT for keywords

Send the topic to ChatGPT and ask for a JSON list of keywords, search intent, and a short insight. ChatGPT is a Latenode AI node.

Write the sheet and send mail

Parse the list in JavaScript, append rows to Google Sheets, then email the same keywords with Gmail.

Requirements

A Google Sheet you can append to

A Gmail account connected in Latenode

A form or app that can POST a topic to the webhook

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work. Plug-and-Play AI nodes are billed separately.

Contact support →

More templates

Browse all templates →

Comprehensive SEO Audit and Optimization Automation

This template starts when you post a website URL to a Latenode webhook. An HTTP request downloads the HTML. JavaScript extracts title, meta, headings, and image alts. OpenAI GPT Assistants reviews that on-page copy. A second HTTP request calls Google PageSpeed Insights with the PageSpeed API key on that request. JavaScript merges the findings into an HTML report, and MailerSend emails it. Connect OpenAI GPT Assistants and MailerSend.

32s$0.0020

Automatically receive SMS alerts for new YouTube videos

This template watches a YouTube channel for new uploads, builds a short text with the video title and link in JavaScript, and sends that SMS with Twilio. Connect YouTube and Twilio. Point the trigger at the channel you want to watch. Put the Twilio Account SID and Auth Token on the Twilio connection.

5s$0.0003

Automatically sync Big Cartel orders to Google Analytics 4

This template receives each Big Cartel order on a webhook, maps order id, total, and items in JavaScript, and sends a purchase event to Google Analytics 4. Point Big Cartel at the Latenode webhook URL. Connect Google Analytics and put access on that connection. Use a JavaScript node to shape the event name and parameters GA4 expects.

10s$0.0006