What is the simplest way to pull data directly from ODK Central to Google Sheets?
Currently there is no out-of-the-box way to pull data into Google Sheets. Google has recently added
Data Connectors for BigQuery and Looker, they might build a connector for general APIs, till then you have two options:
- Manually export CSV from Central and import it in Google Sheets
- Rely on third-party add-ons
I don't endorse any third-party add-ons, use it at your own risk. Make sure to read the terms and conditions + privacy agreement before installing any add-ons
I have just tried API Connector, it does the job
HI. Thanks for your reply. Would it be possible to do a quick step by step guide to link API Connector to Central an pull the headers and data in?