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.
Here are the steps to add leads to Instantly campaign using Google Sheets:
Go to Integrations —> App —> Copy Zapier API Key
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.
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
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.
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.
