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.
You can follow this flow to create a Zap.
Or follow the step-by-step guide below to set up a Zapier:
Find your Instantly API Key. To do this go to Settings —> Integrations —> Copy Zapier API Key
In your Zapier account, click on Create new Zap, select Google Sheets and in the event type, click New spreadsheet row. Click Continue.
Sign in to your Google account, or choose one from already signed-in accounts. Click Continue.
In the Set up trigger step, choose the spreadsheet and the worksheet, click Continue.
Click Test trigger and then Continue.
In the Action step, choose Instantly.
For the Event, select Add lead to campaign. Then click Continue.
Connect your Instantly account by choosing the workspace you already created before, or by Connecting a new workspace and imputing your Zapier API key.
Select the campaign that you want to add the lead to:
Choose if you want to check for duplicates:
Now we can map our fields under set up action.
Please note if you have any custom fields you can map these in the Custom Variables area marked in red. Just make sure these variables are spelled correctly matching your google sheet column headers
Test your action and look out for status "success".
Publish your Zap.