How to make Google Sheets integration bring all data | Community
Skip to main content
Question

How to make Google Sheets integration bring all data


When I integrate the form with Google Sheets to download new responses automatically, fields such as Response Type, Start Date (UTC), Submit Date (UTC) and Network ID. 

But these fields appear when I download the .xls manually.

I really need to know how long it took the user to answer the form.

 

How can I get this data through Google Sheets?

8 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14984 replies
  • June 6, 2024

Hi @andreiaf I believe this data should be pulling through the Google Sheets integration. Do you mind sharing a screenshot of what you’re seeing? (Or not seeing)


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5304 replies
  • June 7, 2024

@Liz  - in the google sheets integration you get the Submitted At date/timestamp and the Token. 

the other fields are only available in the Results download - i have never seen that in the google sheet. 

if i want to get those fields, i download the results file, then pull the data into the Google sheet and synch the data based on a couple of different keys (usually i use the email address as the key field to do the synch/look up)

des


  • Author
  • Explorer
  • 4 replies
  • June 7, 2024

Unfortunately it will have to be done manually then. @Liz is this in the product roadmap perhaps?

 

Thanks, @john.desborough!


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14984 replies
  • June 7, 2024

Ah, shoot, I could have sworn they were on there! This isn’t currently on the roadmap, @andreiaf , but I can share this feedback with the product team. 


  • Navigating the Land
  • 2 replies
  • September 11, 2024

Hi, guys! I am wondering if it is possible to have Start date & time when connecting results to google sheets through integration? I see only submitted at date & time and no start date ;( However, if I download results separately, I will see the Start date & time. Thank you for your time


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14984 replies
  • September 11, 2024

Hi @MariaK I added your post here where we have an existing conversation about this. 


  • Navigating the Land
  • 2 replies
  • September 12, 2024

Thank you, @Liz ! Do I understand correctly this hasn't yet been implemented ? 


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14984 replies
  • September 18, 2024

Hi @MariaK I’m afraid not, but if anything with the integration changes, we’ll post an update here!


Reply