Sending new contacts or leads to Google Sheets uses VGraple CRM's New Contact or New Lead trigger in Zapier, feeding straight into Google Sheets' Create Spreadsheet Row action, so every enquiry lands as a row without anyone exporting a CSV by hand. This walkthrough builds that exact Zap end to end.
Zapier + Sheets: first 5 of 7 steps
- 1Create a new Zap in Zapier and
- 2Choose New Lead as the trigger event
- 3Test the trigger
- 4Add Google Sheets as the action app,
- 5Pick the spreadsheet and worksheet
Before you start
- You need an API key from Settings > API Keys, generated by your organisation's owner, to connect the VGraple CRM app in Zapier.
- You need a Google account connected to Zapier with access to the spreadsheet you want rows added to (or permission to create a new one).
- Decide whether you want New Contact (every person, from any source) or New Lead (specifically a pipeline lead record, carrying source, stage and pipeline fields) before you start, since they trigger on different events.
Steps
- Create a new Zap in Zapier and search for "VGraple CRM" as the trigger app.
Choose New Lead (or New Contact) as the trigger event. Connect your account with an API key if this is your first VGraple CRM Zap; see connecting Zapier if you need the full connection walkthrough.
Test the trigger. Zapier pulls a few recent leads or contacts from
GET /api/v1/leadsorGET /api/v1/contactsto use as sample data for mapping the next step.Add Google Sheets as the action app, and choose Create Spreadsheet Row. Connect your Google account if this is your first Google Sheets Zap.
Pick the spreadsheet and worksheet. Choose an existing sheet with column headers already set up, or a fresh one where you will add headers matching the fields you plan to map.
Map the trigger's fields to your columns. For New Lead, the available fields are
name,phone,email,source,stage_name,pipeline_id,form_name,campaign_nameandcreated_at. Map each to the matching spreadsheet column; leave any you do not need unmapped.Test the action, then turn the Zap on. A test run adds one real row using the sample data from step 3, so check the spreadsheet to confirm it landed correctly before relying on it.
What you will see
Every new lead (or contact) creates one new row at the bottom of your chosen worksheet, populated with whichever fields you mapped, within moments of the lead being created in VGraple CRM, since the trigger is instant rather than a polling check.
Settings and options
| Setting or field | What it does | Default |
|---|---|---|
| Trigger event | New Contact or New Lead | Chosen when building the Zap |
| Spreadsheet + worksheet | Where rows are added | Chosen when building the action step |
| Field mapping | Which trigger field goes in which column | Configured manually per Zap |
| Filter (optional) | Restricts which trigger events continue to the action | Not applied unless you add one |
Troubleshooting
| Symptom | Likely cause | Fix |
|---|---|---|
| No rows appear even though leads are being created | The Zap was never turned on, or its underlying webhook subscription was removed from Settings > Webhooks in VGraple CRM | Check the Zap's status in Zapier, and confirm an active endpoint with a "Zapier" badge exists in Settings > Webhooks |
| A row has blank cells for some fields | The lead did not have that field populated (for example no campaign_name if it did not come from an ad) | Expected; not every lead source populates every field, map only what you actually need |
| Duplicate rows for what looks like one enquiry | The same person submitted a form or messaged more than once, creating separate lead records | This mirrors VGraple CRM's own data; leads are not deduplicated the way contacts are by phone |
| The Zap's test step fails to find any sample data | Your organisation has no leads or contacts yet | Create a test lead manually in VGraple CRM, or lower the test's expectations until real data exists |
| Field values in the sheet are IDs instead of readable names | You mapped stage_id or pipeline_id instead of stage_name | Remap to the _name field where the trigger provides one |
Example
A coaching institute maps New Form Submission's fields (name, phone, form name, page URL) into a spreadsheet counsellors check between calls, giving them a running list of enquiries without opening VGraple CRM at all.
Once this Zap is running, see syncing with HubSpot via Zapier if you also want the same events to reach a CRM rather than a spreadsheet, or connecting Zapier for the full list of available triggers and actions.