Best answer

Fastest way to create a new spreadsheet that captures all available information?

  • 22 September 2022
  • 1 reply
  • 20 views

Many times when I want to create a zap for a new app, the first thing I want to do is capture all available information and record it to a spreadsheet.

I am able to see all available information when I connect my app to a Google sheet. (I think so, anyway.)

I typically see options like this:

id: 48633336
name: Agt Gomey
description:
series_id: 1800969
location_name: Online
location_id: 48259
employee_name: Smiff, Joe
employee_id: 164498
service_name: AYCE
service_id: 88046

There are frequently dozens of data fields--this one has 74.

Is there a way to automatically or quickly make a spreadsheet from that data? Like an option to just give me all the data, and I’ll sort it out later?

For now, I am just copying the data field names.

(There is a small issue with that--on copy and past, the names and values end up on different lines, like this:

id:

48633336
name:

Agt Gomey
description:
series_id:

1800969

Finally, if I’m trying to save all that data, I have to map each field one by one to the columns.

Is there a better way to do this?

icon

Best answer by Troy Tessalone 22 September 2022, 18:46

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Sucesso 

Good question.

You’ll need to map individual data point variables between Zaps steps.

There is no magic option to create a GSheet with columns and headers automatically.