How it works
To move data from botHelp to Google Sheets automatically, use a ready-made scenario — no manual exports.
- Starts when: Google Sheets Trigger
- Check: Select Unprocessed Companies
- Check: Is Domain Already Provided?
- If yes: Merge Rows Which Now All Contain Domains
- Then: Apollo Organization Enrichment
- Then: Summarize Core Business
- Then: Add Company Details
- Check: Loop Over Items (1000 per Batch)
- Then: Split Out Batched Decision Maker Response
- Then: Determine Contact's Department
- Then: Add Contacts
- Check: Loop Over Items For Bulk Enrichment (10 per batch)
- Then: Split Out Batched Enrichment Response
- Then: Enrich Contacts
- Then: Create Apollo People Enrichment Payload
- Then: Apollo Enrich Decision Makers
- Then: Create Apollo People Search URL
- Then: Apollo Find Decision Makers
- If no: Apollo Organization Search
- Then: Add Company Website
- Then: Approve Company Website
- Then: Send Weekly Report
- Then: Retrieve Verified Leads
- Then: Derive Past Week's Lead Gen. Metrics
- Starts when: Weekly Report Trigger
You can launch this botHelp + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.