🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆Set-Up🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆
We have detailed video tutorials for each of the actions/elements we have in this plugin. Watch them to understand and use it at ease.

🟆🟆 You must set up your Google Cloud account and create a Google Cloud Project before you can use this plugin. Takes less than 5 mins if you follow the instructions. It is a one time process which is necessary to get your client-id and client-secret. 🟆🟆

✔ Go to https://console.cloud.google.com/
✔ Log in to your Google account.
✔ Create a new project.
✔ Enable Google Sheets API.
✔ Create credentials for the API along with redirect URI.
✔ Note down the Client-ID and Client-secret.

➸ Step (1 to 6) is explained in detail:
➸ Watch Youtube video here: https://www.youtube.com/watch?v=k1Y-jR1bpOI


🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆Installing the Plugin🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆


✔ Log in to your Bubble account
✔ Go to Plugins
✔ Search for “Google Sheets by Ritz7”
✔ Install the plugin


🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆Using the Plugin🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆🟆


🟆🟆 Note: In all the actions, we have a field named "Authorization". This field should be in the following format: Bearer <Access-Token>. Access Token will be valid for 60 mins from the time it is generated and you can regenerate it using the Refresh Token. And this step is explained in detail here: https://www.youtube.com/watch?v=AsyYBqPsJpA🟆🟆

✔ Drag and drop the element "G-Sheets".

✔ Add an action called "Get Sheets Auth-Code via URL" which requires you can add Client-ID and redirect URI. This will return an URL that needs to be opened.  

Note: The redirect URI should match exactly as you have set while configuring in Google Cloud.

✔ Add Next step: You will have to open the URL you get from the previous step.

Note: This will ask your permission for your app to use your Google Account. Once you permit, the element will automatically fetch the code from the URL.

✔ Generate Auth Token via code: Call an Action "Get_Access_Token-via_Code". This will require you to pass the client-ID, client-secret, code (you will get it from the element 'Gmail' and the param is named as 'Gmail_Auth_Code') and redirect URI (this should match the one added in the Google Cloud Project)

Note: You will also get Refresh Token along with Access token from step-4. You use Refresh Token to get the Access Token once the old Access Token expires.  

✔ Use "Get_Access_Token-via_R-Token" action to get the Access token from Refresh Token. This requires you to provide client-ID, client-secret and refresh token.


🟆🟆 Actions 🟆🟆

➽ Create a SpreadSheet

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ Spreadsheet_Name: Name of the sheet which will be created.

✔ Outputs:
 ➻ Details of the sheet created.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=vesVIdFo5PM


➽ Get Spreadsheet details

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ SpreadsheetId: The ID of the spreadsheet, You can find this ID in the URL of Spreadsheet.

✔ Outputs:
 ➻ Details of the spreadsheet.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=yGFavZPpTKU


➽ Get Spreadsheet Values in batch

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ SpreadsheetId: The ID of the spreadsheet, You can find this ID in the URL of Spreadsheet.
 ➻ ranges: Ex-Sheet1!A1:B2. It will fetch all the values from Sheet1 between A1 and B2.
 ➻ majorDimension: It should be either ROWS or COLUMNS.

✔ Outputs:
 ➻ List of values between the sheet range specified in the input.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=yGFavZPpTKU


➽ Append values to sheets

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ SpreadsheetID: The ID of the spreadsheet, You can find this ID in the URL of Spreadsheet.
 ➻ range: Ex-Sheet1!C1 It appeds values to last row of 'C' Column
 ➻ majorDimension: It should be either ROWS or COLUMNS
 ➻ values: It should contain the values that needs to be added in the sheet.

✔ Outputs:
 ➻ Information about the appended values, such as the updated range.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=xSw8zo7rQrI


➽ Update values of sheets

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ spreadsheetId: The ID of the spreadsheet, You can find this ID in the URL of Spreadsheet
 ➻ range: Ex-Sheet1!C1 It appeds values to last row of 'C' Column.
 ➻ responseValueRenderOption: It should be FORMATTED_VALUE or UNFORMATTED_VALUE or FORMULA.
 ➻ includeValuesInResponse: it should be either true or false.
 ➻ responseDateTimeRenderOption: It should be  FORMATTED_VALUE or SERIAL_NUMBER.
 ➻ majorDimension: It should be either ROWS or COLUMNS.
 ➻ values: It should contain the values that needs to be added in the sheet.

✔ Outputs:
 ➻ Information about the updated values, including the updated range and any formatting options applied.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=P3dsclbZ4Ro


➽ Clear range of  sheets

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ SpreadsheetId: The ID of the spreadsheet, You can find this ID in the URL of Spreadsheet.
 ➻ Range: It should contain the sheet range where data should be cleared.

✔ Outputs:
 ➻ Sheet ID and range will be given where data will be cleared.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=PVnYe-AF_ww


➽ Copy a sheet from one spreadsheet to another

✔ Inputs:
 ➻ Access token: Token is generated from an action "Get Access Token via Code".
 ➻ Spreadsheet-ID: The ID of the spreadsheet. You can find this ID in the URL of Spreadsheet.
 ➻ Sheet-ID: It is the ID of the sheet that needs to be copied to another spreadsheet. You can find in the URL of the spreadsheet which has a parameter called "gid".
 ➻ Dest_Spreadsheet-ID: It is the ID of the spreadsheet where the copied sheet will be added. You can find this ID in the URL of Spreadsheet.

✔ Outputs:
 ➻ Details of the copied sheet such as sheet ID, title etc.

➸ Watch the video for the above action here: https://www.youtube.com/watch?v=W0CfBhurfXk