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
- Navigate to Services in the sidebar
- Click on Google Service
- 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
- Select the desired permissions (Google Sheets Access and/or Gmail Access)
- Click the "Connect Google Account" button
- You'll be redirected to Google's authentication page
- Sign in with your Google account
- Grant the requested permissions
- 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:
- Click the reconnect button (green icon) next to the account
- Re-authenticate with Google
- Grant permissions again
- Account will be refreshed
Disconnect Account
To remove an account:
- Click the disconnect button (red icon) next to the account
- Confirm disconnection
- Account will be removed from the list
Disconnect All Accounts
To remove all connected accounts at once:
- Click the "Disconnect All Accounts" button (top right)
- Confirm the action
- 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 spreadsheetshttps://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 emailshttps://www.googleapis.com/auth/gmail.send- Send emailshttps://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:
- Go to Google Account Permissions
- Find "Excellent Data Filler" in the list
- Click Remove Access
- 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