Hi All,
I have an requirement where i need to read Google sheet data from the google sheet.
In my case i have functionalty where i am exporting grid data and uploading it to user's google drive which is working fine. But now i have another requirement where a user can manualy provide his/her own uploaded google sheet Url in text field in the interface then perform some validations and then submit that google sheet data into db.
so there is any way from which i can achive this.
Discussion posts and replies are publicly visible
Have you read about the Google Sheet CS?
community.appian.com/.../google-sheets-connected-system
Hi David,
thanks for replying Yes i know about google sheet connected system but i have not use it before this and not have much idea about it could please help me or give some steps how can i achieve.
in my case user only have URL of google sheet and requirement is like they have to enter that URL in text field after that all validations regarding sheet ,row, format, will validate after that we will save that google sheet data in db.
below is my moc interface which will be created.
It's not complicated... just create a conencted system against the "Google Sheet", and after that you just have to use one of the methods provided by the smart service...
You have it in the documentation (url provided before)
Keep us informed if you nedd more information or help
Regards