Sync Gmail sent email contacts with Odoo mailing lists
Ready for 3.0What this workflow does
This workflow has 41 nodes and runs on a schedule (every day at ={{ 07 }}:00). It uses only n8n's built-in nodes. It also calls gmail.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every day at ={{ 07 }}:00).
- Step 2: Set Variables (Edit Fields (Set)): sets or maps fields
- Step 3: Get date time (Code): runs custom JavaScript code
- Step 4:Get the list of emails sent 10 days ago. (HTTP Request): calls gmail.googleapis.com
- Step 5: If resultSizeEstimate has a record ==> true (If): checks a condition and branches into true / false
- Step 6: Split Out emails sent (Split Out): splits a list into separate items
- Step 7: Loop Over email sent (Loop Over Items (Split in Batches)): loops over the items in batches
- Step 10: Merge the categorized mailing lists (Code): runs custom JavaScript code
- Step 8: Get email information about thread_id (HTTP Request): calls an HTTP API
- Step 11: If has record deliverableEmails (If): checks a condition and branches into true / false
- Step 9: Handling mail sorting from headers (Code): runs custom JavaScript code
…plus 26 more steps. See the full node list below.
HTTP calls to: gmail.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- No Operation, do nothing
n8n-nodes-base.noOp - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Email Contacts Sync from Sent Mailbox to Odoo This workflow automatically extracts recipient email addresses from previously sent emails, validates and cleans the data, and synchronizes only deliverable contacts into the internal Odoo Mailing List. It also…