GoogleSpreadSheet integration with MuleSoft | Mule 4.4 | Anypoint Studio 7.11.1

Hello guys, this video is demand base from one of my channel member "Mr Abhishek Gupta" who asked for Google spreadsheet integration with MuleSoft flows.
Google Spreadsheet API: developers.google.com/sheets/...
Google Spreadsheet Connector: docs.mulesoft.com/google-shee...

[@manishadeshnamoorthi3246]

can you please create a video on how to integrate mulesoft with online excel connector application to perform any operations

[@jatincoerian]

Hi, Thanks for such a detailed explanation, Is it possible to use the google service account rather than personal account in mule google spreadsheet connector, I am looking for production environment solution, this seems for non prod since everytime we have to trigger the /authorize.

[@sruthikr]

can you please create a video on how to integrate mulesoft with smartsheet application to perform any operations

[@AdamFrankadampfrank]

I don't see the spreadsheet properties in my console. I am able to see the JSON for all of the spreadsheet values, so there is connectivity. However, my console does not show the same feedback that yours does at 15:40. How do you get the spreadsheet property information to appear in your console? Are there setup steps in your logger that do that? What about the 3rd logger that I see at the end of the row?

[@user-lw5mw7jz5y]

hii sir,how to get the spreadsheet id

[@cvasu77]

Thank you for video on google sheets connector. It is good. I have one question on the Update Spreadsheets Values. In the video, the range is hard coded for updating specific cell value. But if I want to update dynamically based on the input, do you know how it can be done. I didn't find anything like getting row id or cell details.
My google sheet has below data.
Ticket Number Maintenance Date
A01 2023/02/10
B01 2023/02/11
C01 2023/02/12
D01 2023/02/13
I received a payload to update the maintenance for ticket C01 from 2023/02/12 to 2023/02/15. I hard coded it is working. But I have to get the range value dynamically.
I didn't find any operation or way to get the ROW id or Cell details so that I can update it any row in the sheet.

[@kalimuthu.s3854]

thank you bro your explanation was good, can u explain how to get the spread sheet id?

[@MuleExpert]

Three possible ways:
1. Open Google drive and create any sample spread sheet. Within URL you will be able to see the SpreadsheetID
2. Use List Drive Files operation available under "google spreadsheet" module and use a flow to trigger it.
3. check out for any existing spreadsheet at GDrive to pick SpreadSheetID.
Best.
Integration Guy

[@kalimuthu.s3854]

@@MuleExpert thank you

[@kalimuthu.s3854]

can u tell me how to give Resoruce owner id ?

[@MuleExpert]

Resource owner id is optional field here as i am using browser based authorization. The resourceOwnerId parameter can be set to an expression. Each time an OAuth-protected operation is executed, that expression will be evaluated, and the token associated with that value will be used.
docs.mulesoft.com/mule-sdk/1.1/oauth-dance#multi-tenancy

[@KarthikKuppachari]

You just skipped on what you setup on genric spreadsheet connector. thats confusing.

[@MuleExpert]

It’s there at 12:00 time stamp. Let me know specific detail you are looking for. Cheers !