How to install and use the mailfloss Google Sheets extension
The mailfloss Google Sheets extension allows you to verify your emails directly from Google Sheets, creating a sheet with all the verification data for your selected emails.
- Go to the Google Marketplace and search for "mailfloss email verifier."
- Click "Install" to add the extension directly to your Google Sheets.
In order to use the extension, you need your API key. Follow the instructions in this article to get it.
Once you install the extension and get your API key, you will be able to use the extension. For this, you’ll need to enter and connect the API key.
- Login to the Google Sheets file where you want to use the extension.
- Click on the "Extensions" tab and, at the bottom, you should find the option "mailfloss email verifier".
- Click on it, and you will see two options: "Verify emails" and "About". The About option contains information that may be helpful about the extension, and Verify emails is where you should enter to get started. Select that option.
- A sidebar will open, where you will find an introduction and instructions for the extension, plus a box where you should enter your API key.
- Enter your API key and click on the submit button.
- Wait a few seconds for it to connect and, if the API key is correct, you should be in.
- Once inside the extension, you will see your credits at the bottom of the sidebar. You will also see a button that says "Verify email addresses".
- Select the email addresses you want to verify from your spreadsheet and click "Verify email addresses".
- A new sheet will be created with the name mailfloss results, where you will find all the verification data of your selected email addresses.
- To verify more email addresses, the steps are the same. Just select the emails you want and click Verify. A new sheet will be created with the verification results.
You will notice that there is a tab called "Settings". The extension gives you the option of whether you want to get your results color coded. In case you activate this setting, you will see that in the newly created sheet with the verification data, the column called emails will be colored green or red depending on their validation status.
Below this option, you will see the button "Change API key". In case you need to, the extension will go back to its initial page where you will have to enter the API key again in order to use the extension.
When you close the extension it will remember your API key, so you don't need to enter it every time you open it. The extension will ask for your API key only the first time you're logging in, and in case you want to change it in the future.
