To automate your process even further, you can automatically import the leads to your campaign when you create a new row in Google Sheets by setting up a Zapier. You can follow this article to learn the flow of how to create a Zap.
Here are the steps to set up as a guide on how to add the leads in Instantly using Google Sheets:
Find your Instantly API Key. To do this go to Settings —> Integrations —> Copy Zapier API Key
Before we start the Zap flow make a new column inside of your lead list sheet called "Remove Lead?". This column will be essential as it’ll be the trigger for the flow.
Go to Zapier and connect Google Sheets, then choose Event: New or Updated Spreadsheet Row.
Connect your Google Sheets account by signing in or selecting an already connected account.
Set up the trigger by selecting the spreadsheet and worksheet. (For the Trigger Column we will be using the “Remove Lead?” field we made in our spreadsheet).
Test your trigger and move onto the filter by the Zapier function.
Click on the "+" button, and add the filter.
Set your filter as the Remove Lead? column from our spreadsheet and the operator as “Text Exactly Matches” and the value as “Yes”.
Connect Instantly:
Select event: Remove lead from campaign
Select Instantly workspace or connect it by pasting the API key.
Under Set up action select the campaign of your choice and then select the email address from your Google Sheet list. Test the Zap and publish it.
Congrats! You can now remove leads in Instantly from Google Sheets!