Integration
Automate with Google Sheets
Google Sheets is the most-used spreadsheet on the planet. NVS turns it from a passive data store into an active automation hub — pulling from CRMs, pushing to databases, and triggering workflows the moment data changes.
Use Cases
Every hour, pending leads are pulled from Sheets, and each one is checked against Gmail. If a thread already exists the row is marked 'contacted'; otherwise the outreach email goes out.
Trigger
Every Hour
schedule.cron
Scheduled trigger fires hourly to process the outreach queue.
Get Pending Leads
google.sheets
Fetches all rows where status=ready_to_send from the leads sheet.
Loop
Each Lead
nvs.loop
Iterates over every pending lead row, processing them sequentially.
IF
Thread Exists?
gmail.search
Searches Gmail for an existing thread with the lead's email address.
YES
Output
Mark Contacted
google.sheets
Row updated: status=already_contacted. No duplicate email sent.
NO
Send Email
gmail.send
Cold outreach email sent using the lead's name and company.
Output
Mark Sent
google.sheets
Row updated: status=sent, sent_at=now.
Clicks and conversions data from Google Ads are fetched in parallel, merged by campaign ID, and written to Sheets and Notion simultaneously.
Trigger
Daily 8am
schedule.cron
Scheduled trigger fires each morning to collect yesterday's ad data.
Fetch Clicks
google-ads.api
Clicks data fetched for all campaigns, date=yesterday.
Fetch Conversions
google-ads.api
Conversion data fetched in parallel from the same date range.
Merge by Campaign
nvs.merge
Both datasets joined on campaign_id to create unified rows.
Write to Sheets
google.sheets
Merged performance rows appended to the Daily Stats tab.
Output
Create Notion Entry
notion.database
A summary page created in Notion with campaign-level insights.
Every new Shopify order appends a timestamped row to a revenue tracking sheet. Orders over $500 are flagged automatically so high-value purchases never slip through without review.
Trigger
Order Created
shopify.trigger
Fires the moment a new order is confirmed in Shopify.
Extract Fields
nvs.set
Order ID, customer name, product, amount, and timestamp mapped for the sheet row.
Append Row
google.sheets
New row inserted with all order fields. Sheet grows in real time with every sale.
IF
Order > $500?
nvs.condition
Checks whether this is a high-value order needing special attention.
YES
Output
Flag VIP Row
google.sheets
Row color and VIP tag applied. High-value orders stand out immediately.
NO
Output
Done
nvs.end
Standard order logged. No further action needed.
Ready to automate Google Sheets?
We'll map your workflow, connect your tools, and build it in days, not months.
Book a Free Strategy Call →