Introduction
To make sure you can set up and launch your DropSaaS prospecting workflow with confidence, we’ve recorded a step-by-step video that walks you through the entire process—from importing the n8n automation to setting up your Canva and Google Sheet integrations.
This video is designed for non-technical agency owners who want to:
Understand how the entire workflow functions
Learn how to edit and personalize inputs (keywords, locations, etc.)
Set up all required credentials (SERP API, Google Sheets, Canva, SMTP, and Vapi if using Advanced version)
Modify the workflow for Base or Pro versions
Launch and schedule automations
By the end of this video, you’ll know exactly how to:
Scrape leads from Google Maps
Extract emails and phone numbers
Generate personalized reports from Canva
Automatically send cold emails
Use AI cold calling (Advanced only)
What You’ll Learn in the Video
The video will cover:
1. Overview of the Prospecting Strategy
How local prospecting works using automation
The difference between Base, Pro, and Advanced workflows
What you can achieve with zero ad spend
2. How to Import the n8n JSON File
Step-by-step import into your n8n dashboard
Where to locate the input block
How to modify the JSON for different cities and keywords
3. How to Set Up All the Required Credentials
SERP API Key
Google Sheets OAuth
Canva API Integration (PKCE setup, scopes, and redirect URL)
SMTP for email delivery
Vapi setup (only for Advanced)
4. Canva Report Setup
How to open the Canva Reputation Report Template
How to customize design and branding
How to use Data Autofill with consistent variables
How to publish the template and get the Template ID
5. Google Sheets Template Setup
How to copy and link the sheet to the automation
How each column is used
How statuses update automatically as the automation runs
6. Cold Email Configuration
Where to write and customize your message
How the report PDF gets attached
How call-to-actions work inside the email
7. AI Calling with Vapi (Advanced only)
How the assistant works
What happens when email is collected by phone
How it’s automatically added to the CRM and the report is sent
8. Scheduling Your Workflow
How to run it daily or weekly
How to rotate verticals (gyms, dentists, salons, etc.)
How to let your calendar fill up automatically
Conclusion
This is your all-in-one video companion to master DropSaaS’s most powerful automation system. Whether you’re launching your first campaign or scaling daily lead generation, this video will remove any guesswork.
You’ll find the full video tutorial embedded below (or linked, depending on your view).
Once you’re done watching, head back to the other articles in this knowledge base to:
Download the files
Customize your Canva template
Configure your tools
Let’s automate your outreach and grow your SaaS business faster than ever.
— Team DropSaaS