To automate your process even further, you can automatically import leads to your campaign when you create a new row in Google Sheets by setting up a Zapier.
Step 1: Copy Your Zapier API Key from Instantly
Go to Integrations -> Apps
Copy Zapier API Key
Step 2: Configure Google Sheets Event
In your Zapier account, click on Create new Zap, select Google Sheets, and in the event type, choose Event: New or Updated Spreadsheet Row.
Connect your Google Sheets account by signing in or selecting an already connected account.
In the Configure step, choose the spreadsheet, the worksheet, and the trigger column, and click Continue.
Click Test trigger and then Continue.
Step 3: Configure Instantly Action
Add Instantly and select the event: Add lead to campaign.
Select Instantly account or connect it by pasting the Zapier API key.
Select the campaign that you want to add the lead to.
Choose if you want to skip leads that already exist in other campaigns.
Choose if you want to launch the campaign after adding leads to it
Step 4: Map Your Fields
Now we can map our fields.
Type / to map each column. The Email field is mandatory.
For any custom fields, you can map them as Custom Variables. Just make sure these variables are spelled correctly, matching your Google Sheet column headers.
Step 5: Test and Publish Your Zap
Test your action and look out for the status "success". Publish your Zap.
You can also check the campaign to confirm if the test lead has been added successfully.
If the status shows success but the test lead is not added to the campaign, it may have been skipped because it already exists in other campaigns.
