n8n

How to Automate Gmail Airtable Topic Emails?

Send topic based emails on a set schedule without writing the content by hand. People can join or leave with simple forms, and messages include text and images. This fits teams that want a light newsletter or daily tips without buying a full email tool.

Each morning at 9am, a schedule checks Airtable for active subscribers in daily, weekly, and surprise segments. It spins each subscriber into a separate subworkflow so one failure does not stop the rest. A chat model creates a short fact using Wikipedia as a source. OpenAI generates an image, the image is resized, and Gmail sends the email. After the send, the workflow updates Last Sent in Airtable and stores execution data so you can filter logs.

You only need to connect Gmail, Airtable, OpenAI, and Groq. Map Airtable fields like Email, Topic, Status, Interval, Last Sent, and id. Expect less manual work, faster delivery, and easy scaling as your list grows. Use it for education tips, product facts, or daily trivia.

What are the key features?

  • Schedule Trigger runs every day at 9am and routes daily, weekly and surprise segments.
  • Airtable search nodes filter active subscribers with formulas and Last Sent checks.
  • Execute Workflow runs each subscriber in parallel so one error does not stop others.
  • Form triggers power subscribe and unsubscribe with a prefilled ID for safe opt out.
  • Groq chat model builds the fact using Wikipedia context and window memory.
  • OpenAI generates an image and the image is resized before sending.
  • Gmail sends the email and a confirmation to new signups with an unsubscribe link.
  • Airtable update writes Last Sent for clear tracking and reporting.
  • Execution Data node enables filtered execution logs on n8n Cloud.

What are the benefits?

  • Reduce manual content prep from 2 hours to 5 minutes per send
  • Automate 100 percent of recurring emails at 9am for daily and weekly lists
  • Handle up to 10 times more subscribers with concurrent subworkflows
  • Improve data accuracy by logging Last Sent back to Airtable every time
  • Connect Gmail, Airtable, OpenAI, Groq and Wikipedia in one flow

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 Gmail, Airtable, OpenAI, Groq and Wikipedia. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, open the Airtable nodes and create a new Airtable Personal Access Token credential. Name it clearly, then paste your token from the Airtable API page.
  4. Open the Gmail nodes and create a new Gmail OAuth2 credential. Follow the on screen steps to connect your Google account and confirm the sending address.
  5. Open the OpenAI nodes and create a new OpenAI API Key credential. Get the key from your OpenAI account and paste it into n8n.
  6. Open the Groq chat model node and create a new Groq API Key credential. Copy the key from your Groq dashboard and add it in n8n.
  7. Configure Airtable fields: in each Airtable node, set the Base and Table to your list. Make sure fields exist and match names like id, Email, Topic, Status, Interval and Last Sent.
  8. Set form paths and fields: open the Subscribe Form and Unsubscribe Form nodes. Confirm field labels and required fields. Publish the forms and copy the public URLs.
  9. Adjust the schedule if needed: open the Schedule Trigger and change the hour if you do not want 9am.
  10. Review email content: in Set Email Vars and Gmail nodes, set the From address, subject and body. Remove any internal emails you do not want copied.
  11. Test end to end: submit the Subscribe Form, check Airtable for a new record, and confirm the confirmation email arrives. Manually run the workflow to trigger a send and verify Last Sent updates in Airtable.
  12. Troubleshoot common issues: if Gmail fails, recheck OAuth consent. If Airtable updates fail, confirm record ids and field names. If AI steps fail, verify API keys and try a simpler prompt.

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

Wikipedia

Sign up

Free: $0 (public Wikimedia APIs). Enterprise Free: $0 with 5,000 on‑demand requests / mo and twice‑monthly snapshots

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.