Skip to main content
madhup0003
madhup0003
September 18, 2024
Question

Read data from Google sheet URL

  • September 18, 2024
  • 3 replies
  • 0 views

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.

    3 replies

    davidj137213
    davidj137213
    September 18, 2024

    Have you read about  the Google Sheet CS?

    community.appian.com/.../google-sheets-connected-system

    madhup0003
    madhup0003Author
    September 19, 2024

    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.

    davidj137213
    davidj137213
    September 19, 2024

    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)

    /cfs-filesystemfile/__key/appian-appmarket-files/a0649666_2D00_ad0f_2D00_4708_2D00_a853_2D00_4c79426b97db/Snip2.jpg?_=637447869460547264

    Keep us informed if you nedd more information or help

    Regards

    Terms & ConditionsAccessibility statement