n8n

How to Automate Gmail and Airtable Email Campaigns?

Turn signups into helpful emails without manual work. The setup collects topics from subscribers and sends fresh content on a daily or weekly plan. It fits teams that want a simple content campaign with clear opt out.

Each morning at 9 AM a schedule checks Airtable for active records. One search finds daily users, another finds weekly users that have not been sent in seven days, and a third supports surprise sends. For every match, a subflow starts in parallel so slow emails do not block others. The content engine uses a chat model with Wikipedia context and short memory to write a fact, then an image is created and resized. Gmail delivers both items with an unsubscribe link, and the run updates Last Sent in Airtable for tracking. Execution Data makes it easy to filter runs when you review logs.

Setup needs Airtable, Gmail, Groq, and OpenAI accounts. Publish the subscribe and unsubscribe forms; the unsubscribe uses an ID so no one can remove others by email. Expect faster delivery, cleaner records, and a repeatable drip that scales as your list grows. Common uses include educational tips, product facts, or community updates.

What are the key features?

  • Daily schedule at 9 AM processes daily, weekly, and surprise segments
  • Airtable searches use filter formulas for status, interval, and last sent date
  • Execute Workflow runs each subscriber in parallel without waiting
  • AI writer uses a Groq chat model with Wikipedia context to create a short fact
  • Image generator uses OpenAI and a resize step for inbox friendly images
  • Gmail sends text and image together and includes an unsubscribe link
  • Execution Data helps filter and review run logs for easier support
  • Airtable update logs the Last Sent time for each contact

What are the benefits?

  • Reduce manual sending from 2 hours per day to about 5 minutes
  • Automate 100 percent of recurring email prep and delivery
  • Improve list accuracy by updating Last Sent on every run
  • Handle many subscribers at the same time with parallel runs
  • Connect Airtable, Gmail, Groq, OpenAI, and Wikipedia in one flow
  • Lower unsubscribe risk by using a secure ID instead of email

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, Groq and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. In Airtable, create a base and a table with fields: id, Email, Status, Interval, Topic, Last Sent. Use values like active for Status and daily, weekly, or surprise for Interval.
  4. In the n8n credentials manager, open the Airtable credential for each Airtable node and connect with a Personal Access Token. Select your base and table in Search daily, Search weekly, Search surprise, Create Subscriber, Update Subscriber, and Log Last Sent.
  5. Connect Gmail: open the Send Message and confirmation email nodes, choose Gmail, click Create new credential, and complete OAuth. Send a test email to confirm delivery.
  6. Connect Groq: create an API key in your Groq account, add a Groq credential in n8n, and select it on the Groq Chat Model node. Pick a suitable chat model and run a test item.
  7. Connect OpenAI: create an API key in your OpenAI account, add it as an OpenAI credential in n8n, and select it on the Generate Image node. Choose the image size then test a prompt.
  8. Open the Subscribe Form node and adjust fields for email, topic, and interval. Publish the form and copy the URL. Open the Unsubscribe Form, keep the ID field, and publish its URL as well.
  9. Open the Schedule Trigger and set the time to 9 AM in your preferred timezone. Save the workflow and activate it.
  10. Verify Airtable filters: the weekly search should only match records where Last Sent is at least seven days old and Status is active.
  11. Check the Execute Workflow node options: mode set to each and do not wait for the subworkflow. This enables parallel processing for scale.
  12. Review the Content Generation Agent, Wikipedia, and Window Buffer Memory nodes. Ensure the agent reads from the model and context and returns a short fact.
  13. Confirm the Resize Image and Set Email Vars nodes map the image and text into the email body and attachments. Send a test to yourself to verify the layout.
  14. Ensure Log Last Sent maps the Airtable record id and writes the current timestamp. After a send, confirm Last Sent updates in Airtable.
  15. Troubleshoot: if no emails send, check Airtable filters and Status values, verify Gmail OAuth is connected, confirm OpenAI and Groq keys are active, and review Execution Data logs for errors.

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.