Note: Google Sheet is available on the free and pro version.
To integrate with Google-Sheet follow, the below steps.
Process of Authorization and Integration
Search & Select Google Sheets from the actions pages.
Integration Name: Set the proper integration name. Default it's taken “Google Sheet”.
Client ID & Secret: For client ID & secret you have to visit the Google API console. If you already have any Client ID & secret before then copy this to the field. If you don’t have any then you have to create a new client ID & secret.
If you don’t have any then you have to create a new client ID & secret.
Client ID & Secret: For client ID & secret, you have to visit the Google API console. If you already have any Client ID & secret before then, copy this to the field. If you don't have any, then you have to create a new client ID & secret
To create Google OAuth-2, you have to visit the Google API console. If you don't have any Projects in Google Console, you have to create projects in Console.
To create a Project, click on My First Project -> Then Click New Project.
In the Project name field, put the Project name of your choices. If you have any Organization for the Location field, you can put your Organization or leave it as default.
Now click on the "Create" button to create a Project.
Now go to the Google API Console Dashboard, and you have to enable Google sheets API and Google Drive API.
To enable Google Sheets API and Google Drive API to go to Dashboard and select ENABLE APIS AND SERVICE.
Search Google Sheets API in this search bar. Now Select Google sheets API and enable API by clicking on the "Enable" button.
For enabling Google Drive API, follow the steps of Google Sheets API
If you have already created an application under OAuth Consent Screen, or you have to create an application. And select the Scopes tab, and you have to add Google Sheets API and Google Drive API scopes.
To add Google Sheets API and Google Drive API scopes. Click on the "ADD OR REMOVE SCOPES" button. Then search and add Google Sheets API and Google Drive API scopes and click on the "Update" button.
After complete these steps, to get new Client Id & Client secret information go to Google API CONSOL=> Credentials=>Create Credentials=> OAuth Client ID => Select Application Type=> Give a Client Name => Add home page URL => Add authorized URL.
Register all the information and get your client ID & Secret information from google sheet.
Now give Client ID & Secret to the fields & click Authorize & you are ready to import all your data from WordPress to your Google Sheet.
Select the specific Spreadsheet from the drop-down menu which you have created before on Google Sheet. Then select the Worksheet that belongs to the selected spreadsheet.
Now specify the header row. By default, the first row of the worksheet is considered as a header row.
Click on the Refresh button.
You can now map the Bit form fields with the necessary Google fields. You can send custom values on Google Sheet. After mapping the desired fields, click on Next.
To save the integration process click on Finish & Save.
- We have an option in every integration "Timeline," where you can check integration success or error status.