Bear Brown
← All N8N workflows
AI & researchAgentAirtableCodeEdit ImageExecute Workflow

receive schedule events and search airtable and gmail

Configured with Agent, Airtable, Edit Image, Execute Workflow, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗24 nodes · MIT
Workflow preview
TriggerSchedule TriggerSchedule TriggerData storeSearch dailyAirtableData storeSearch weeklyAirtableMessagingconfirmation email1GmailSubworkflowExecute WorkflowExecute WorkflowTransformCreate EventEdit FieldsTriggerExecute WorkflowTriggerExecute Workflow TriggerTriggerUnsubscribe FormForm TriggerTransformSet Email VarsEdit FieldsData storeLog Last SentAirtableData storeSearch surpriseAirtableRoutingShould Send = TrueFilterCodeShould Send?CodeData storeCreate SubscriberAirtableData storeUpdate SubscriberAirtableTriggerSubscribe FormForm TriggerIntegrationExecution DataExecution DataData storeWindow Buffer MemoryMemory Buffer WindowIntegrationWikipediaTool WikipediaAI & modelsContent GenerationAgentAgentAI & modelsGroq Chat ModelLM Chat GroqAI & modelsGenerate ImageOpen AiFiles / mediaResize ImageEdit ImageMessagingSend MessageGmail

Node categories in this workflow

  • Trigger
  • Data store
  • Messaging
  • Subworkflow
  • Transform
  • Routing
  • Code
  • Integration
  • AI & models
  • Files / media

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Schedule TriggerTriggerSchedule TriggerSee node parameters
Search dailyData storeAirtablesearch
Search weeklyData storeAirtablesearch
confirmation email1MessagingGmailSee node parameters
Execute WorkflowSubworkflowExecute WorkflowSee node parameters
Create EventTransformEdit FieldsSee node parameters
Execute Workflow TriggerTriggerExecute Workflow TriggerSee node parameters
Unsubscribe FormTriggerForm TriggerSee node parameters
Set Email VarsTransformEdit FieldsSee node parameters
Log Last SentData storeAirtableupdate
Search surpriseData storeAirtablesearch
Should Send = TrueRoutingFilterSee node parameters
Should Send?CodeCodeSee node parameters
Create SubscriberData storeAirtableupsert
Update SubscriberData storeAirtableupdate
Subscribe FormTriggerForm TriggerSee node parameters
Execution DataIntegrationExecution DataSee node parameters
Window Buffer MemoryData storeMemory Buffer WindowSee node parameters
WikipediaIntegrationTool WikipediaSee node parameters
Content Generation AgentAI & modelsAgentSee node parameters
Groq Chat ModelAI & modelsLM Chat GroqSee node parameters
Generate ImageAI & modelsOpen Aiimage
Resize ImageFiles / mediaEdit Imageresize
Send MessageMessagingGmailSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • airtableTokenApi
  • gmailOAuth2
  • groqApi
  • openAiApi

Workflow notes

4. Using Subworkflows to run executions concurrently

4. Using Subworkflows to run executions concurrently

This configuration is desired when sequential execution is slow and unnecessary. Also if one email fails, it doesn't fail the execution for everyone else.

1. Subscribe flow

1. Subscribe flow

Use a form to allow users to subscribe to the service.

2. Unsubscribe flow

2. Unsubscribe flow

  • Uses Form's pre-fill field feature to identify user
  • Doesn't use "email" as identifier so you can't unsubscribe others
3. Scheduled Trigger

3. Scheduled Trigger

  • Runs every day at 9am
  • Handles all 3 frequency types
  • Send emails concurrently
5. Use Execution Data to Filter Logs

5. Use Execution Data to Filter Logs

If you've registered for community+ or are on n8n cloud, best practice is to use execution node to allow filtering of execution logs.

6. Use AI to Generate Factoid and Image

6. Use AI to Generate Factoid and Image

Use an AI agent to automate the generation of factoids as requested by the user. This is a simple example but we recommend a adding a unique touch to stand out from the crowd!

7. Send Email to User

7. Send Email to User

Finally, send a message to the user with both text and image. Log the event in the Airtable for later analysis if required.

Try It Out!

Try It Out!

This n8n templates demonstrates how to build a simple subscriber service entirely in n8n using n8n forms as a frontend, n8n generally as the backend and Airtable as the storage layer.

This template in particular shows a fully automated service to send automated messages containing facts about a topic the user requested for.

How it works

  • An n8n form is setup up to allow users to subscribe with a desired topic and interval of which to recieve messages via n8n forms which is then added to the Airtable.
  • A scheduled trigger is executed every morning and searches for subscribers to send messages for based on their desired intervals.
  • Once found, Subscribers are sent to a subworkflow which performs the text content generation via an AI agent and also uses a vision model to generate an image.
  • Both are attached to an email which is sent to the subscriber. This email also includes an unsubscribe link.
  • The unsubscribe flow works similarly via n8n form interface which when submitted disables further scheduled emails to the user.

How to use

  • Make a copy of sample Airtable here: https://airtable.com/appL3dptT6ZTSzY9v/shrLukHafy5bwDRfD
  • Make sure the workflow is "activated" and the forms are available and reachable by your audience.

Need Help?

Join the Discord or ask in the Forum!

Happy Hacking!

receive schedule events and search airtable and gmail

receive schedule events and search airtable and gmail

Purpose and structure

This folder contains the receive schedule events and search airtable and gmail workflow. Its executable nodes use agent, airtable, code, editImage, executeWorkflow, executeWorkflowTrigger, executionData, filter, formTrigger, gmail, lmChatGroq, memoryBufferWindow, openAi, scheduleTrigger, set, toolWikipedia. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Schedule Trigger, Execute Workflow Trigger, Unsubscribe Form, Subscribe Form

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Code/0658_Code_Schedule_Create_Scheduled.json MIT; preserve source notices.

More in AI & research

"Hey Siri, Ask Agent" workflow#️⃣Nostr #damus AI Powered Reporting + Gmail + Telegram(G) - Email Classification