Skip to main content
Best answer

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

  • September 21, 2022
  • 1 reply
  • 24 views

Sucesso

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?

Best answer by Troy Tessalone

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.

View original
Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31398 replies
  • Answer
  • September 22, 2022

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.