What is Gmail Gmail offers free cloud storage for storing emails in the web. Gmail makes emailing, chatting, drafting and archiving your mails and conversations easy and convenient. It’s necessary to create a Gmail account.
Note: Gmail data source is available in On-Premises Deployment but not in Syncfusion Managed Cloud Server.
You can connect to web services of popular site like
Gmail connection type. To enable this connection, follow the given steps.
Data Source button in the configuration panel to add a new data connection.
CREATE NEW to launch a new connection from the connection type panel.
Gmail connection button in the connection panel.
Connect an Account in the window opens.
The login window opens to authorize the user.
Enter an appropriate username and password. The authorization window opens.
Allow in the authorization window. The datasource window opens.
To get data through datasource window, follow the given steps:
IMPORTANT: Refer to the Gmail API Documentation to build a query for discovering more data requests. Test the query before entering it in the URL text box. Use Google APIs Explorer, to build the query.
Choose appropriate method for the API. Refer API documentation link given below URL text box to get appropriate API.
Add Header information, if necessary.
Choose appropriate refresh settings for API.
Choose appropriate data format.
Authentication type will be set as
Gmail automatically, if the login gets success.
Click connect to get data.
The choose schema(s) window opens as follows. You can select the schema and click
Now, you can get into the data design view window with selected table schema.
Drag and drop the table and click
Save button to save the data source with valid name.
Note: Google OAuth credentials are required for the On-Premises Deployment but not needed in Syncfusion Managed Cloud Server.
Go to the Google API Console at Google API Console.
Select the existing project or create a new project by clicking on the Select Project dropdown at the top of the page and give your project a name. Then click on Create.
Click on the menu and select APIs & services, and then click on the Enabled APIs and services button.
To enable the required Google API in Bold BI, click on the +ENABLE APIS AND SERVICES.
Search and enable the People API by clicking the ENABLE button.
NOTE: Need to enable the required APIs to connect the connector in the Bold BI.
|Google Drive API
Google Drive Activity API
Drive Lable API
|Google Sheets API
AdSense Host API
AdSense Management API
Google Analytics V4
Google Analytics API
Google Analytics Reporting API
Google Analytics Data API
|Google Ads API
|Google Search Console
|Google Search Console API
|Google Calendar API
Click on the OAuth consent screen and follow the prompts and provide the required details.
In the second step, click on ADD OR REMOVE SCOPES and add the required read scopes for the API that needs to be connected in Bold BI. Then click on Save and Continue.
|Google Analytics V4
|Google Ads V4
|Google Search Console
To create OAuth 2.0 credentials, click the Credentials menu item in the left sidebar. Click the + CREATE CREDENTIALS button and select the “OAuth client ID”.
Choose the Web application application type, and enter a name for your OAuth 2.0 app.
Add the Redirect URL as mentioned here by clicking Add URI.
NOTE: The Bold BI redirect URL should be added in the proper format. Please refer to this URL structure,
After creating your OAuth 2.0 client, you will be able to view and copy your Client ID and Client Secret from the Google API Console.
NOTE: Save the client ID and client secret in Bold BI by following the OAuth Configuration guide for more details.