Connect a Google Sheet to create contacts automatically

📍 Where to find it: Data Sync → Google Sheet

Connect a Google Sheet to Madyis Hub: each new row of the spreadsheet becomes a contact in your CRM, re-read automatically every few minutes.

How it works

You paste the CSV export link of your Google Sheet. Madyis Hub analyzes it to detect the columns (name, email, phone…), then a robot re-reads the spreadsheet about every 5 minutes. For each new row, it creates or updates the matching contact, without ever creating a duplicate, and files it according to the chosen destination. You can add filters (e.g. only import rows from a certain city) and apply an automatic tag.

Step by step

1. In Google Sheets, open "File → Share → Publish to the web", then publish the sheet in "Comma-separated values (.csv)" format and copy the link you get.
2. In Madyis Hub, go to "Data Sync" then click the "Google Sheet" card.
3. Click "New", give the sync a name, paste the link into the "Source" field and click "Analyze".
4. Check the detected columns and, if needed, indicate the phone column.
5. Leave the default action "CRM" (create the contact); sending messages is now done in Flows.
6. In "Where to file the contacts", choose the pipeline stage and/or the folder.
7. Optionally add an automatic tag and filters, then save and activate.

Good to know

• The link must be a public CSV export link: a classic "view" sharing link is not enough.
• The sync reads NEW rows: do not delete old rows to "restart", it will not recreate contacts that have already been processed.
• To check without sending anything, use the test button (simulation) which shows what would be done.
• For large, recurring volumes, the Google Sheet is the best option (unlike one-off import, which is capped).
• The default country code (e.g. 33) converts national numbers (06…) to international format.