n8n

How to Generate Gmail Newsletters from Airtable?

Send topic based emails on a set schedule without writing content by hand. People sign up with a simple form, pick a topic and how often to get messages, and the system delivers short text and an image to their inbox. It suits small teams that want a light newsletter or a drip series without building a custom app.

At 9am each day a schedule checks Airtable for active subscribers that are due for daily or weekly sends. A code and filter step also handles a surprise option so only some users get a bonus message. Each subscriber is passed to a subworkflow to run in parallel, which speeds up delivery and prevents one failure from stopping others. Groq drafts the fact with optional Wikipedia context, OpenAI creates an image, the image is resized, Gmail sends the email, and the run logs Last Sent back to Airtable. A subscribe confirmation goes out right away, and an unsubscribe form uses a safe ID instead of email to avoid abuse. Execution Data helps you filter logs for cleaner reviews.

You need Airtable, Gmail, OpenAI, and Groq accounts, then connect them and map your base and fields. Publish both forms and add the unsubscribe link in your email. Expect less writing time, clean records in Airtable, and the ability to serve many readers at once. Common uses include daily tips, product facts, onboarding lessons, and internal learning notes.

What are the key features?

  • Subscribe and unsubscribe forms collect topic and interval, with a safe ID to protect users
  • Daily 9am schedule finds due contacts for daily and weekly messages and also supports a surprise option
  • Airtable searches use clear formulas for status interval and last sent date
  • Execute Workflow runs one subworkflow per subscriber without waiting, so messages send in parallel
  • Groq chat model drafts the text and can use Wikipedia as context while Window Buffer Memory maintains short context
  • OpenAI generates an image and a resize step prepares it for email
  • Gmail sends a confirmation on signup and the main message with text and image
  • Airtable update writes Last Sent back for reliable tracking and Execution Data helps filter logs

What are the benefits?

  • Reduce manual newsletter work from hours to minutes
  • Automate up to 90 percent of repetitive sending and list checks
  • Improve data accuracy by logging each send to Airtable to prevent misses and duplicates
  • Support hundreds of concurrent sends by running each subscriber in a separate subworkflow
  • Connect Airtable Gmail OpenAI and Groq in one flow so nothing is copied by hand

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Airtable, Gmail, OpenAI and Groq. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create an Airtable Personal Access Token. In your Airtable account, create a token with read and write access to the base that stores subscribers. Paste the token in n8n and give the credential a clear name.
  4. In the n8n credentials manager, add Gmail using OAuth2. Click Create new credential, choose Gmail, sign in to the Google account that will send emails, and allow send and read mail scopes.
  5. In the n8n credentials manager, add OpenAI. Go to the OpenAI API page, create an API key, paste it into the credential, and save.
  6. In the n8n credentials manager, add Groq. Go to the Groq API page, create an API key, paste it into the credential, and save. Select the Groq model in the chat node.
  7. Open each Airtable node. Set the Base and Table to your subscriber table. Confirm fields such as Status, Interval, Last Sent, Email, Topic, and id match your column names.
  8. Open the Subscribe Form and Unsubscribe Form nodes. Set a clear path for the unsubscribe form and publish both forms. Use the form prefill field to pass the subscriber ID in links.
  9. Open the Gmail nodes. In the confirmation node, review the subject and body. In Set Email Vars remove any test addresses and keep the dynamic to field. Add the unsubscribe link that points to your Unsubscribe Form path.
  10. Check the Execute Workflow node options. Keep wait for subworkflow off so sends run in parallel for better speed and reliability.
  11. Set the Schedule Trigger to your local time if needed and activate the workflow. Run a manual test once to confirm the search and send path works.
  12. Validation: Submit the Subscribe Form with a test email. Confirm a new record appears in Airtable, the confirmation email arrives, the scheduled run sends the message with text and image, and Last Sent updates in Airtable.
  13. Troubleshooting: If no records are found, review the Airtable filter formulas and field names. If emails do not send, check Gmail credential scopes and daily limits. If the image is missing, check your OpenAI key and quota. If content is empty, confirm the Groq credential and model. Use the Execution Data node and the n8n executions list to filter and inspect runs.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Free tier: $0, API key usable via API (rate‑limited)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.