Google Sheets to SinergiaCRM: Automate Event Participant Registration

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

How it works

This workflow automates the registration of event participants in SinergiaCRM from a Google Sheets spreadsheet. A Google Sheets Trigger watches for new rows with pending registrations. The flow checks if the participant already exists in SinergiaCRM by NIF (national ID). If the contact exists, it creates a relationship and registers them for an event. If the contact doesn’t exist, it first creates the contact, then adds the relationship and event registration. Finally, it marks the row as "Processed" in the original spreadsheet to avoid duplicate entries.

Set up steps

Connect your Google Sheets and SinergiaCRM accounts using OAuth credentials. Replace the sample Google Sheet ID and worksheet name with your own. Ensure the spreadsheet contains the following columns: First name, Last name, NIF, Email, Event ID, Relation type, Registration date, and Relation date. Add the appropriate values in the "To CRM" and "Processed" columns to control processing logic. Review sticky notes inside the workflow for additional guidance and customization tips.