This template reads the next newsletter topic from Google Sheets, writes HTML with ChatGPT, saves the file to Google Drive, and emails you a review copy with Gmail.
When you mark that row approved, Gmail sends the newsletter to the client list in the sheet and the status is updated. Connect Google Sheets, Google Drive, and Gmail. ChatGPT is a Latenode AI step.
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
On a schedule, Google Sheets returns the pending topic, status, and the client email list.
ChatGPT writes the HTML. JavaScript shapes it, and Google Drive stores the file.
Gmail emails you the draft and the sheet is marked generated.
When you mark the row approved, Gmail sends the newsletter to the client list and the sheet is marked sent.
Add a Google Sheets connection. Use a spreadsheet with topic, status, Drive file URL, and a client email list.
Add Google Drive and Gmail connections. Choose the Drive folder for newsletter files and the mailbox that should send.
Send the sheet topic to ChatGPT and ask for HTML. ChatGPT is a Latenode AI step. Save the file to Drive, email yourself the draft, then update the row status.
When the row status is approved, Gmail sends the Drive file to the client emails in the sheet and marks the row sent. Run a test topic before you leave the schedule on.
FAQ
More templates
This template starts when someone mentions your Slack bot, sends the message text to ChatGPT, and posts the reply in that channel. Use it for status updates or a channel assistant. Put the Slack bot token on the Slack connection. ChatGPT is Latenode AI, so you do not paste an OpenAI key.
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.
This template receives an incoming WhatsApp Business Cloud message on a Latenode webhook, pulls the text and sender phone in JavaScript, detects intent with Google Dialogflow ES, and sends the reply with WhatsApp Business Cloud. Connect WhatsApp Business Cloud and Dialogflow. Put the Cloud API token on the WhatsApp connection and the Google key on the Dialogflow connection.
