← Back to Learn
Step 4IntegrationsIntermediate8-10 min
Google Sheets and Gmail Integrations
Connect Google services securely, map sheet data, and use it to upsert contacts and power workflows.
Step-by-Step Walkthrough
Step 1
Connect Google Sheets
Authorize read access via OAuth to let InWren access selected sheets for workflow use.
Step 2
Create field mapping
Choose spreadsheet and tab, then map sheet headers to structured data fields.
Step 3
Use mapping in workflow
Set Google Sheets as trigger and configure Upsert Contact action to create or update contacts.
Step 4
Connect Gmail
Authorize sending and reply retrieval so campaign responses appear in the Replies section.
Practical Deep Dive
How These Screens Work in Real Usage
This section explains how each screen should be used, what good setup looks like, and the main gotchas to avoid.
How the Screens Work
- ●Integrations overview: connect accounts and verify connection status before building automations.
- ●Google Sheets mapping screen: map each column deliberately; critical fields should never be left ambiguous.
- ●Workflow builder: test one small sample sync before enabling full automation.
What Good Setup Looks Like
- ●Connection status is healthy and recently verified.
- ●Mapped columns are stable and owned by one person/team to avoid accidental header changes.
- ●Workflow run logs show predictable create/update behavior.
Gotchas to Watch
- ●Sheet header edits after mapping often break imports quietly.
- ●Shared spreadsheets with frequent manual edits can create dirty data.
- ●Disconnected Gmail can halt reply visibility without obvious campaign-side errors.
If Something Looks Wrong
- ●If sync appears stuck, reconnect integration and run a small controlled test row.
- ●If contacts are malformed, inspect source sheet formatting and blank cells.
- ●If replies are absent, verify integration health and check reply inbox view filters.