Skip to main content
Question

Formatting Webhook and creating Google Sheet


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.

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.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

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:

 


  • Author
  • New
  • 1 reply
  • August 15, 2024

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.


Troy Tessalone
Forum|alt.badge.img+14

@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