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.

I’m looking to convert some data from form submissions on WordPress Elementor that I have a Zap set up to retrieve via Webhook. I need the data formatted into columns and rows, and then loaded onto a Google Sheet. I have the webhook working fine, I just don’t know how to format the data and have it continually update a Google Sheet.

Hi @ZKOELE 

For us to have more context, post screenshots with how the data is returned in the Zap trigger step.

 

If the data is raw JSON, then try this:

 

I don’t think the format is JSON (unfamiliar with that)

Attaching a screenshot of what the data looks like in the Catch Hook trigger.

@ZKOELE 

Data in the Zap trigger step is already parsed into variable that can be mapped to Zap action steps input fields.

Help link for configuring Zap action steps: https://zapier.com/help/create/basics/set-up-your-zap-action

 

Terms & Conditions