Google Sheets
Use a sheet as the source of a contact list: new rows are added and changed rows update the contacts, on a schedule.
Connect
- In Google Sheets: Share › Anyone with the link › Viewer (or File › Share › Publish to the web as CSV). No Google account needed on our side.
- Portal › Integrations › Google Sheets: paste the link (the tab of the link is used:
#gid=…). - Choose the contact list, map the columns (one must be the phone), the schedule and the country for national numbers. Save, then Sync now.
Private sheet? Click Connect Google on the connection: read-only access to Sheets (OAuth, token stored encrypted).
How the sync works
- Each sync reads the whole sheet as CSV and runs the normal contact importer: invalid numbers, duplicates, blacklisted and opted-out numbers are skipped and counted (rejects file in Contacts › Imports), existing contacts are updated.
- The mapping is kept by column name: moving columns is fine; renaming the phone column stops the sync with a clear error.
- Rows removed from the sheet are not deleted from the list.
- Up to 20 MB per sheet. A sync does not start while the previous one is still importing.