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.