The link provided in the xlsform settings under the submission_url does not direct the submissions to google sheet

[Kal_Lam]

Hi @karenmcdonnellca,

@karenmcdonnellca

Question 1: If all submissions go to a specific Kobo user, can we pull the submissions into our system from whatever storage Kobo uses for submissions? How does Kobo store those submissions? Can a third party system extract data from it?

Yes, this can be done! Please see the support article where a user is able to extract data from the KoBoToolbox server using Excel Power Query and PowerBI.

@karenmcdonnellca

Question 2: The app doesn’t currently support the ability to set a form submission URL that goes to a Google Sheet. Can Kobo user servers be set up to automatically forward all the data they gather to a destination URL like a Google Sheet?

If you wish to have your google sheet as your server which stores data go through the discussion that has happened earlier in the community forum. It should help you guide on how to do the same.

@karenmcdonnellca

Question 3: Aside from being able to set up a server so that it forwards all submissions to a destination URL, can we download all the data from that server? There’s a “Collections” API in the documentation but we need to know more about how it works and how to set it up.

Could you share the link for this so that we could help sort it out for you.

GOOD DAY!