Note: You can import contacts from Google Sheets in two ways: by downloading and uploading files directly, or by setting up the Google Sheets integration for automatic synchronization. This document covers the continuous integration from Google Sheets document to Trustmary

Continuous integration of contacts into Trustmary

Importing contacts from Google Sheets enables you to leverage your existing contact databases, automatically sync new contacts, and organize your feedback campaigns using data you already maintain in your spreadsheets.

Step-by-step guide

Find the integration and authenticate to Google Sheets

1. Navigate to Settings > Integrations in your Trustmary dashboard.
2. Find Google Sheets integration
3. Authorize Google Sheets access
4. Click Connect to Google Sheets to begin the authorization process. You'll be redirected to Google to grant Trustmary permission to access your spreadsheets.
5. In the Google authorization screen, review the permissions and click Allow to grant Trustmary access to your Google Sheets.

Set up the integration in Trustmary

1. Back in Trustmary, click Add trigger. You'll see a list of your Google Sheets. Select the spreadsheet containing your contacts.
2. Set up when contacts should be imported by configuring the trigger. Choose Sheet updated to automatically import new contacts when your spreadsheet changes.
3. Map your Google Sheets columns to Trustmary contact fields. Ensure the email column is properly mapped as it's required for contact creation.
4. Select which Trustmary contact lists should receive the imported contacts. You can choose a survey to be sent if new contacts are imported, or you can simply import them into a custom contact list.
5. Save and activate the integration. Review your configuration and click Save to activate the integration. Your contacts will now be automatically imported when your Google Sheet is updated.

Test the integration

Add a test contact to your Google Sheet to verify the integration is working correctly. The contact should appear in your selected Trustmary list within a few minutes.

Clean your data: Ensure email addresses are valid and properly formatted

Use consistent formatting: Keep your column headers and data consistent

Include required fields: Email is mandatory; name and company are recommended

Test with small batches: Start with a small number of contacts to verify your setup

Regular maintenance: For the integration method, regularly review and clean your Google Sheets data

Troubleshooting

Integration not syncing: Check that your Google Sheets permissions are still valid and refresh the connection if needed.

Duplicate contacts: Trustmary automatically handles duplicates based on email addresses.

File upload errors: Ensure your file format is supported (.csv, .xlsx, .xls) and doesn't exceed size limits.

Updated on: 23/09/2025