topic Re: Update survey using data from google sheet in ArcGIS Survey123 Questions

Update survey using data from google sheet

DanielLeón81 — Thu, 27 Jul 2023 20:18:22 GMT

Hello everyone,

I am developing a form with survey123 connect and I have a doubt. The form needs to receive data that comes from a Google Sheet spreadsheet that is updated from time to time, this data is stored in without coordinates, it only has the addresses with which I hope to run the esri World Geocoding Service to approximate its location and later update with field output the exact location.

My question is: What method do you recommend to integrate the google Sheet spreadsheet with the survey with survey 123 connect?

This is something new for me, as I have usually only created simple forms, I look forward to your recommendations. I am also open to using ArcGIS Field Maps if it is easier to create the workflow there.

Thank you very much in advance.

Regards

Re: Update survey using data from google sheet

DougBrowning — Thu, 27 Jul 2023 20:34:37 GMT

There is a python package to read google sheets I used once and it was pretty slick. You could grab the sheet, change to csv, then upload it to AGOL using the Python API. Make that CSV a linked content in 123 and that should do it. Make it a bat file on task scheduler and it would be all good. Just have Pro logged in and it will use its token.

Hope that helps

Re: Update survey using data from google sheet

DanielLeón81 — Fri, 28 Jul 2023 16:09:46 GMT

Ohh Thaanks