Importance of Mapping Fields

  • 28 November 2022
  • 1 reply
  • 726 views

Userlevel 7
Badge +8

Setting up Zaps as a beginner can be frustrating.

We’ve all been there. Honestly, the more advanced the Zaps, the more potential for an error to pop up. That’s why it’s important to consider how our Zaps are “mapped out” to ensure we set ourselves up for success.

We have tons of users that come into our community looking for assistance, and one of the most common mistakes we see involves mapping fields.

So what is “mapping”?

Essentially, it is how a user sets up their Zap, and connects information being pulled from the trigger to the action.

It’s how your Zap gets from point A to point B. Like if you were to follow a map yourself, it tells that Zap where to go to be successful in reaching its designated location (i.e., information from one Google Sheet to another).

Your trigger is the “when” a Zap is set-off, the action is your “then this will happen” in response to your trigger, and your mapping of fields is your “what” in relation to data being pulled from your trigger to your action.

I find that information makes the most sense when a scenario is given.

Let’s say you’re a local landlord with a few rental properties around your city, and you keep track of tenants in your handy dandy Google Sheets workbook.

You also want to keep track of “Increase Notices” in another Google Sheets workbook, but you’d like to automate it so that when you draft one letter, it also drafts the others simultaneously.

The first step you want to tackle here is to create custom column headers. This is so you can choose a column to pull from the specific data cells from your Tenant List in your trigger.

RnJxEjfsQh3HuL9jfPdChvulzfeNDxj9buA51lurkiHTriX-S5skNQI2D6b9Z_Ftt1a5aCVZw6ZemTfkzDj8_pTzMq3_QokGKqUmQ2fScHiizoB8fOVICC0DDifgJi_e36dFVu-FCZ1Rv2TTp6LDzmqVaG2yblkPyLTZxlBKzuceypWeG7sR5LS1HlaznA

 

Now, you’ll want to set up your action. “Create Spreadsheet Row” seems most appropriate for this. This is where we’ll connect the custom column headers from both sheets. 
This is done so you can map over each data cell to be replicated in your Increase Notice sheet.

 

UxYgpWWjV5glDbfW7VDhnN-Emncj0WBFbozShCLPtlwF_yRRbe4iv3e9bvs8ZMEttAWOiJfDLRnWCd0GlJaqT3umFqoKEjRO9zreRtDmINcn0v9Rl81weddlXSLQcp8A7KUO59EW5xCTPM3Mq7bSRikDz4MqKdhDFqERgtkIhQGnuK5SGa_4pqIoPe4S

 

After testing this out, although the trigger is labeled as instant, I found that this Zap works with about a 5-minute delay. Keep in mind, even though while setting up your Zap you’ll be mapping a single sample value, this value is just a representation of what will be there in the future.


The opposite of mapping fields would be typing in a static value. If you enter a static value, the same value that you enter will remain constant every time the Zap runs. 
Thus, why dynamic values (mapping fields) is the best route when you want to set up a Zap with ever-changing data.

 

If you are interested in learning more, we have an excellent resource video that goes a bit more in-depth.


1 reply

Hi, I am working on integration: Clickup -> Zapier -> DocuSign

 

I have an issue that Zapier don't fill custom fields in DocuSign document.

How we can manage with that? 
Zappier don’t send those text fields where occures ::false::
someone knows why is that happenning?

Reply