Is there an easier way to connect 100s of different forms to Google Sheets instead of clicking connect in each form? | Community
Skip to main content
Answered

Is there an easier way to connect 100s of different forms to Google Sheets instead of clicking connect in each form?

  • October 16, 2021
  • 1 reply
  • 33 views

Using the web interface I estimate it takes a few minutes to connect each form to google sheets (or any other option), based on my organization’s dataset it’ll take a few days to connect all the forms I have.

 

I don’t need to use google sheets, I just need a reliable way to bulk export all the forms, ideally in some sort of ‘live updating’ format like Excel or Sheets and in a table format (csv, xlsx etc.) instead of JSON.

Best answer by Liz

Hi @azadea Welcome to the community! If you haven’t already had a chance to look at our APIs, this might be an option for you. 

For example, if you’re trying to export the responses, you could do that using the Responses API. If you want the form information itself, the Create API could work for this. 

Would either of those APIs help? 

View original

1 reply

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14840 replies
  • Answer
  • October 18, 2021

Hi @azadea Welcome to the community! If you haven’t already had a chance to look at our APIs, this might be an option for you. 

For example, if you’re trying to export the responses, you could do that using the Responses API. If you want the form information itself, the Create API could work for this. 

Would either of those APIs help? 


Reply