Sync Gmail sent email contacts with Odoo mailing lists

Bby bhsoft· via n8n.io

End

noOp

Step 1: Schedule Trigger every day at 7 AM

Step 2: Set Variables

Step 3: Get date time

Step 4:Get the list of emails sent 10 days ago.

gmail.googleapis.com

Step 5: If resultSizeEstimate has a record ==> true

Step 6: Split Out emails sent

splitOut

Step 7: Loop Over email sent

noOp

Step 8: Get email information about thread_id

Step 9: Handling mail sorting from headers

Step 10: Merge the categorized mailing lists

Step 14: Search email in Mailing List Contacts

Step 15: If number of records is not 0 = true

Step 16.1" Check if list_ids contains 020.Good-to-send

Step 16.2: Add new email in Mailing List Contacts

Step 17: If list_ids = true

Step 18: Update email in Mailing List Contacts

Step 19: Return all data from step 10.

Step 20: Split Out bounceEmails

splitOut

Step 21: Loop Over bounceEmails

noOp

Step 22: Search email in Blacklisted Email Addresses

Step 23: If number of records is not 0 = true

Step 24.1" Check if reason_type contains Bounced

Step 24.2: Add new email in Blacklisted Email Addresses

Step 25: If list_ids = true

Step 26: Update Reason Type of email in Blacklisted Email Addresses

Step 27: If has record bounceEmails

Step 28: Split Out bounceEmails

splitOut

Step 29: Loop Over bounceEmails

noOp

Step 30: Search email in Blacklisted Email Addresses

Step 31: If number of records is not 0 = true

Step 32.1: Check if reason_type contains Bounced

Step 32.2: Add new email in Blacklisted Email Addresses

Step 33: If list_ids = true

Step 34: Update Reason Type of email in Blacklisted Email Addresses

End1

noOp

End2

noOp

End3

noOp

Step 11: If has record deliverableEmails

Step 12: Split Out deliverableEmails list

splitOut

Step 13: Loop Over deliverableEmails

noOp