Hey everyone,
I’m working on a Zapier automation and I’m stuck. Is there a way to get all the fields from a previous step as one big object, like JSON? Right now I have to set each field individually in the input data, which is a pain.
I’ve got a step that pulls responses from a Google Form. What I want to do is take all those responses and format them nicely in an email, showing all the questions and answers. But I don’t want to have to manually set up each field.
Does anyone know if this is doable in Zapier? It would save me a ton of time if I could just grab everything at once instead of field by field.
Thanks for any help you can give!
I’ve been in your shoes, and I found a workaround that might help. Instead of using Zapier’s built-in tools, I ended up writing a small custom JavaScript code step. It lets you access all the data from the previous step as a single object.
Here’s what you do: Add a ‘Code by Zapier’ step after your Google Form trigger. In the code editor, use something like:
output = {allData: inputData};
This bundles everything into a single ‘allData’ object. Then in your email step, you can use ‘{{allData}}’ to access everything at once. You’ll need to do some string manipulation to format it nicely, but it’s way more flexible than mapping fields individually.
It takes a bit of coding knowledge, but it’s incredibly powerful once you get it set up. Good luck!
hey scarlett, try using zapier’s ‘utilities’ step to format data. select your google form fields to convert them into one json object. hope this helps!
You’re in luck! There’s a handy feature in Zapier called ‘Formatter by Zapier’ that can do exactly what you’re looking for. In your Zap, add a Formatter step after your Google Form trigger. Choose the ‘Text’ action, then select ‘Line-item to text’. This will let you combine all your form fields into a single text output, which you can then use in your email step. You’ll need to specify the format you want (e.g. ‘Question: {{question}}, Answer: {{answer}}’) for each field. It’s a bit of setup, but once done, you won’t need to map individual fields anymore. This should streamline your workflow significantly.