About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Getting JSON results into Sheets

  • 12 June 2020
  • 1 reply
  • 1441 views
kaisaj

Hello.

I have a webhook GET from an API that is returning results.

The results return successfully, but I cannot for the live of me figure out how to get these grouped results to create individual rows in Sheets or Excel.  At this point, I would be equally grateful for the creation of a csv file or anyway to use these grouped results individual.

 

E.g., the webhook returns (with corresponding results to categories omitted for privacy):

 

84.

city

timezone

isp

latitude

session_start_unix_timestamp

type

session

eventUnixTimestamp

resolution

platform

exit_query_id

company_org

session_referrer

eventEsTimestamp

browser

exit_root_url

country_name

total_number_visits

entry_title

85.

city

timezone

isp

latitude

session_start_unix_timestamp

type

session

eventUnixTimestamp

resolution

platform

exit_query_id

company_org

session_referrer

eventEsTimestamp

browser

exit_root_url

country_name

total_number_visits

entry_title

 

but any subsequent export of data populates all results being populated in to one row or one result.

 

My apologies if this request for advice is painfully ignorant.  I’m grateful for any kind of help.

 

Thank you!

 

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

nicksimard
Userlevel 7
Badge +11

Hi @kaisaj!

Without seeing the Zap itself, and based solely on what you’ve described, it seems like you’re getting the data back as line items. The good news is that the Google Sheets integration has an option to create multiple rows, using line items as the input. So if you had a column for each of those items (type, sessions, etc) and mapped the output of your GET step it should create one row per line item. 

This is the one you’ll want to select:

Can you give that a shot to see if it works for you?

Terms & Conditions