Best answer

Creating a reference table for later reference with key-value pairs

  • 21 April 2022
  • 3 replies
  • 69 views

Hi there,

I have some zaps that have many steps. When I receive a webhook it may have a lot of data. 

Currently, if I change the trigger, I have to go through each step and reassign the value to the new trigger in each step. It involves a lot of scrolling and searching.

I usually try and refer to a previous step, rather than the original as it means less steps have to be changed. But it still means going through each step - it’s time consuming, messy and annoying. 

What I am looking for is a utility or technique that allows me to create a reference table for the key fields I would like to use in a zap. Each subsequent step would reference this table, not the original node.

For example, I receive an invoice from Stripe. It has hundreds of fields, but I’m only going to reference key customer data in all my subsequent next steps (e.g. putting customer in CRM, Delivery software, Customer Service Database, Inventory etc.)

I want to create a table like this one, that simply outputs all of those fields.

This way I know that every subsequent step is referencing this table, and I just need to change a reference in the table for it to filter through to everything. 

It’s also much neater, as i no longer need to scrolling through endless webhook fields.

Can anyone think of a workaround for this? I was mucking around with some of the line-items to text but couldn’t get it to happen.

I could also I guess use a Google Sheets zap and just never look at the sheet and just use the output, but that seems a bit weird. A Zapier utility would be better.

icon

Best answer by Troy Tessalone 21 April 2022, 06:02

View original

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

Userlevel 7
Badge +14

Hi @Sosa 

Good question.

OPTIONS

  1. Storage by Zapier: https://zapier.com/apps/storage/help
  2. Code step: https://zapier.com/apps/code/help
  3. Airtable Base/GSheet
Userlevel 7
Badge +14

@Sosa 

FYI: List of all apps by Zapier: https://zapier.com/apps/categories/zapier-tools

Hi @Sosa 

Good question.

OPTIONS

  1. Storage by Zapier: https://zapier.com/apps/storage/help
  2. Code step: https://zapier.com/apps/code/help
  3. Airtable Base/GSheet

Ah great thanks - for anyone searching, I’m using Storage by Zapier, the “Set Child Value” function to achieve the above.