Excellent Data Filler

Appearance

Google Service ​

Connect multiple Google accounts with different permissions for Sheets and Gmail integration.

Overview ​

The Google Service feature allows you to connect and manage multiple Google accounts within the extension. You can grant specific permissions for Google Sheets and Gmail access, enabling seamless integration with Google's services for automation workflows.

Key Features ​

  • Multiple Account Support - Connect multiple Google accounts simultaneously
  • Granular Permissions - Choose specific permissions for each account
  • Google Sheets Access - Read and write spreadsheet data
  • Gmail Access - Send and read emails programmatically
  • Account Management - Easy connection and disconnection of accounts
  • Permission Control - Enable/disable permissions as needed

Connecting a Google Account ​

Step 1: Access Google Service Settings ​

  1. Navigate to Services in the sidebar
  2. Click on Google Service
  3. You'll see the Google Services page

Step 2: Select Permissions ​

Choose the permissions you want to grant to your Google account. At least one permission must be selected.

Available Permissions: ​

Google Sheets Access

  • Permission: Read and write spreadsheets
  • Use Case: Fetch data from Google Sheets, write automation results
  • Field Types: Fetch Google Sheet Data

Gmail Access

  • Permission: Send and read emails
  • Use Case: Fetch emails, send automated emails, extract verification codes
  • Field Types: Fetch Mail (Gmail), Fetch Single Mail (Gmail), Send Mail (Gmail)

Step 3: Connect Account ​

  1. Select the desired permissions (Google Sheets Access and/or Gmail Access)
  2. Click the "Connect Google Account" button
  3. You'll be redirected to Google's authentication page
  4. Sign in with your Google account
  5. Grant the requested permissions
  6. You'll be redirected back to the extension

Connected Accounts ​

Once connected, your accounts will appear in the Connected Accounts section.

Account Information ​

Each connected account displays:

  • Profile - Profile picture and initial
  • Account - Name and email address
  • Permissions - Active permissions (Sheets, Gmail)
  • Connected - Connection date and time, expiration status
  • Actions - Reconnect or disconnect options

Account Status ​

Active Account:

  • Shows connection date and time
  • Displays active permissions as badges
  • Available for use in field types

Expired Account:

  • Shows "Expired" status
  • Requires reconnection
  • Click reconnect button to refresh permissions

Managing Accounts ​

Reconnect Account ​

If an account expires or loses permissions:

  1. Click the reconnect button (green icon) next to the account
  2. Re-authenticate with Google
  3. Grant permissions again
  4. Account will be refreshed

Disconnect Account ​

To remove an account:

  1. Click the disconnect button (red icon) next to the account
  2. Confirm disconnection
  3. Account will be removed from the list

Disconnect All Accounts ​

To remove all connected accounts at once:

  1. Click the "Disconnect All Accounts" button (top right)
  2. Confirm the action
  3. All accounts will be disconnected

Using Google Service in Field Types ​

Google Sheets Integration ​

Field Types:

Requirements:

  • Connected Google account with Google Sheets Access permission
  • Spreadsheet ID
  • Sheet name and range

Example Use Cases:

  • Import data from Google Sheets for form filling
  • Sync spreadsheet data with web forms
  • Use Google Sheets as a data source

Gmail Integration ​

Field Types:

Requirements:

  • Connected Google account with Gmail Access permission
  • Search queries for fetching emails
  • Email content for sending

Example Use Cases:

  • Fetch verification codes from emails
  • Monitor inbox for specific messages
  • Send automated email notifications
  • Extract data from email content

Permission Scopes ​

Google Sheets Access ​

Scopes Granted:

  • https://www.googleapis.com/auth/spreadsheets - Read and write spreadsheets
  • https://www.googleapis.com/auth/drive.readonly - View Google Drive files

What You Can Do:

  • Read data from any spreadsheet you have access to
  • Write data to spreadsheets
  • Create new spreadsheets
  • Update existing spreadsheet content

Gmail Access ​

Scopes Granted:

  • https://www.googleapis.com/auth/gmail.readonly - Read emails
  • https://www.googleapis.com/auth/gmail.send - Send emails
  • https://www.googleapis.com/auth/gmail.modify - Modify email labels

What You Can Do:

  • Read emails from inbox
  • Search emails with queries
  • Send emails programmatically
  • Mark emails as read/unread
  • Manage email labels

Security & Privacy ​

Data Security ​

  • OAuth 2.0 Authentication - Secure authentication using Google's OAuth 2.0
  • Token Storage - Tokens are stored securely in the extension
  • No Password Storage - Your Google password is never stored
  • Revocable Access - You can revoke access anytime from Google Account settings

Privacy ​

  • Minimal Permissions - Only request permissions you need
  • User Control - You control which accounts to connect
  • No Data Sharing - Your data is not shared with third parties
  • Local Processing - Data processing happens locally in your browser

Revoking Access ​

To revoke extension access from Google:

  1. Go to Google Account Permissions
  2. Find "Excellent Data Filler" in the list
  3. Click Remove Access
  4. Confirm revocation

Best Practices ​

Do's ​

  • Use separate accounts - Use different Google accounts for different purposes
  • Grant minimal permissions - Only enable permissions you need
  • Monitor expiration - Reconnect accounts before they expire
  • Test connections - Verify account access before automation
  • Keep accounts organized - Use descriptive account names

Don'ts ​

  • Don't share accounts - Each user should use their own Google account
  • Don't grant unnecessary permissions - Only enable required permissions
  • Don't ignore expiration - Reconnect expired accounts promptly
  • Don't use personal accounts for automation - Consider using dedicated accounts
  • Don't forget to disconnect - Remove unused accounts

Troubleshooting ​

Cannot Connect Account ​

Solution:

  • Check your internet connection
  • Ensure pop-ups are allowed for the extension
  • Try a different browser or incognito mode
  • Clear browser cache and cookies

Permission Denied Errors ​

Solution:

  • Verify the account has the required permissions
  • Reconnect the account to refresh permissions
  • Check if the account has access to the resource (spreadsheet/email)

Account Shows as Expired ​

Solution:

  • Click the reconnect button
  • Re-authenticate with Google
  • Grant permissions again

Cannot Access Spreadsheet/Email ​

Solution:

  • Verify the Google account has access to the resource
  • Check if the correct account is selected in field settings
  • Ensure permissions are granted correctly