About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

HubSpot Error: Property "propertiestoretrievenote" does not exist

  • 10 October 2023
  • 11 replies
  • 153 views
E

Hello everyone,

I am struggling a bit with, what would seem to be a straightforward automation.

I have a spreadsheet in Google Sheets where I keep track of all my clients and use that to keep them up to date.

I created an automation in HubSpot that creates a contact every time a new row to the sheet is added. After that it creates a deal.

I have a column in my sheet that I use to update the deal progress and I want it to also automatically change the deal progress in HubSpot.

When I made the automation I received the following error:

Property values were not valid: [{"isValid":false,"message":"Property \"properties_to_retrieve_note\" does not exist","error":"PROPERTY_DOESNT_EXIST","name":"properties_to_retrieve_note","localizedErrorMessage":"Property \"properties_to_retrieve_note\" doe

I checked if I named the deals in my spreadsheet correctly (not using the names in the Pipeline, but the ones that HS displays - the deal IDs) and checked for Typos and everything looks fine.

Tried the AI but it was no help at all.

 

Am I going about this the correct way at all? And if I am, how can I get the google sheet column to connect to the deal stage?

 

Thank you!

11 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Eri 

Good question.

It’s likely the HubSpot field you are trying to use is a dropdown list of options.

In the Zap editor, open the dropdown list to the see the options.

Each option has 2 values. (top/bottom)

The bottom value for each option is the value HubSpot expects.

So you may need to translate the values from your GSheet to what HubSpot expects.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E

Thank you for your reply, @Troy Tessalone 

 

These are the values provided by HS:

I have set-up my Spreadsheet to use the grey text:

 

 

Unfortunately, even with this set-up I get the same error when I try to test it:

 

I have also tried using the bold text, but get the same error.

 

I have checked for typos and even went as far as copy/paste the deal IDs from HS into my Spreadsheet, but nothing changes - I get the same error every time.

Troy Tessalone
Userlevel 7
Badge +14

@Eri 

The error may be related to a different field and how it is configured.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E

@Troy Tessalone 

 

All the previous steps were completed without an issue. In this one, I have only two things - the deal ID, which I get from a previous action and the Deal Stage that I am trying to update.

 

I also manually checked the deal ID to make sure it is the right one.

 

I guess I will have to look for another way to automate this,

 

Thanks

Troy Tessalone
Userlevel 7
Badge +14

@Eri 

We would need to see full screenshots with how your Zap steps are configured to have enough context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E

@Troy Tessalone 

 

Apologies for the late reply:

 

Here is the full automation.

 

This is the trigger:

 

 

First Action:

Second Action:

 

 

Third Action (which I am not sure I even need)

 

 

And the last one:

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Eri 

You only need step 4 is values from step 4 are mapped to following action steps.

 

Check to make sure the Deal Pipeline and Deal Stage are valid combos.

 

Look at the Properties to Retrieve section.

Can you post screenshots with how HubSpot step 5 is configured at the bottom of the Action section?

 

Can you provide the full error message?

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E

@Troy Tessalone 

 

The ID and properties were correct, but for some reason it still was not working. What I ended up doing is deleting the whole Zap and creating it a new with the same settings and somehow it worked.

 

After that I reworked it using HS Associations for better results and Zapier Formatter and it is running as intended.

 

Should I post the final automation here in case someone else needs it?

Troy Tessalone
Userlevel 7
Badge +14

@Eri 

It’s encouraged to share your solutions so others can learn and benefit, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E

@Troy Tessalone 

 

Those are the steps that I took:

 

 

Action 1:

 

Find Contact in HubSpot:

 

Action 2: Find Associations in HS: - locates the deals for the contract that we found with Action 1

 

 

Action 3: Formatter by Zapier - If there is more than 1 deal associated with the contact

 

 

Action 4: Update Deal in HS using the Formatter from Action 3:

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Eri 

Can you provide the full error message?

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions