The n8n workflow itself is free; you only pay for OpenAI usage and any Google API quotas you exceed.

What do I need before importing?

Google Sheets, Google Drive, Gmail, and OpenAI credentials plus a sheet with the exact column headers listed in the setup.

How do I import this into n8n?

Download the workflow JSON, go to n8n, click Import, paste the JSON, then add the four required credentials.

Automate Newsletter Creation & Client Delivery with GPT-4O, Google Sheets

Verified

Automates AI-powered newsletter creation and client email delivery from Google Sheets.

n8nAI & LLMIntermediate👁 20 views

Open template

Updated 2026-06-15

What this workflow does

The workflow pulls data from Google Sheets, uses OpenAI to create newsletter content, saves outputs to Google Drive, and delivers final versions through Gmail with approval steps.

It supports marketing teams, agencies, content creators, and small businesses that manage recurring client newsletters from a central spreadsheet.

Who is this for?

Marketing teams, agencies, and content creators who manage multiple client newsletters. Small businesses looking to automate regular customer communications from a spreadsheet.

What problem it solves

Manually creating, approving, storing, and emailing newsletters is time-consuming and error-prone. This workflow removes repetitive steps by pulling topics from Google Sheets, generating content with AI, and handling delivery plus status tracking.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Agency client newsletters

Pull pending topics for multiple clients, generate AI content, store in Drive, then email each client only after status is approved.

Weekly internal updates

Schedule the workflow to pull new topics every Monday, generate HTML newsletters, and send them to a fixed internal list while updating the sheet.

Creator content distribution

Add fresh topics to the sheet, trigger manual generation with GPT-4o, review the Drive file, then send the final version to subscribers via Gmail.

How the workflow works

The 5 nodes in this automation, in order.

1Google SheetsgoogleSheets
2Google DrivegoogleDrive
3Gmailgmail
4Codecode
5OpenAI@n8n/n8n-nodes-langchain.openAi

Apps & integrations used

Google SheetsGoogle DriveGmailOpenAI

How to set up Automate Newsletter Creation & Client Delivery with GPT-4O, Google Sheets

1Import the workflow JSON into n8n and connect your Google account to all Google Sheets nodes.
2Create a sheet named Newsletter_Management with columns ID, Topic, Client Name, Client Email, Status, Created Date, Send Date.
3Add your OpenAI API key in the credentials section for the content-generation node.
4Connect Google Drive credentials so generated HTML files can be saved automatically.
5Set up Gmail credentials for both admin notifications and client email delivery.
6Activate the workflow and test with one row set to Status = Pending.

How to customize this workflow

→Swap GPT-4o for GPT-4o-mini or Claude to reduce cost or change writing style.
→Change the manual trigger to a Schedule node for fully automatic weekly runs.
→Add an approval step via Slack or email before the Gmail send node.
→Extend the sheet with extra columns like Tone or Length and pass them to the OpenAI prompt.