Skip to main content

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

 


Reply