Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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!

 

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