Step 1: Open Google Sheets Integration
Navigate to Integrations from the left menu and select Google Sheets integration
Description:
The Google Sheets integration allows users to connect their Google account and automatically validate email addresses from Google Sheets data.
Step 2: Choose a Google Account
Click Sign in with Google and select the Google account you want to connect.
Description:
Choose the Google account that contains the spreadsheet you wish to use for email validation.
Step 3: Google Verification Warning
If Google displays an unverified application warning, click Continue.
Description:
This screen may appear during development or testing. Proceed to continue the authentication process.
Step 4: Sign in to Google
Verify the selected Google account and proceed.
Description:
Confirm that you are signing in with the correct Google account before granting permissions.
Step 5: Grant Required Permissions
Review the permissions requested by the application and click Continue.
Description:
The application requires access to Google Sheets in order to read spreadsheet data and perform email validation operations.
Step 6: Successful Connection
After authorization, the Google account will appear as connected.
Description:
The integration status will show that the Google account has been successfully linked to the application.
Step 7: Create Validation
Click Google Sheets validation process.
Description:
This option allows users to select a spreadsheet and configure validation settings.
Step 8: Configure Validation Details
Select the required information:
- Google Sheet Selection
- Sheet Name
- Email Column
Description:
Provide the necessary configuration details so the system can identify which emails should be validated.
Step 9: Start Validation Process
Review the configuration and click Validate Now.
Description:
The system will begin processing the selected spreadsheet and validating email addresses.
Step 10: Confirm Validation
Verify the selected options and click Start Validation in the confirmation popup.
Description:
This confirmation step ensures that the correct spreadsheet and settings have been selected before processing begins.
Step 11: View Validation Results
After completion, review the validation summary and download the processed results if required.
Description:
The validation history page displays:
- Total records processed
- Valid emails
- Invalid emails
- Catch-all emails
- Validation status
- Download option for results
