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 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.

  • Home
  • Get Help
  • Troubleshooting
  • Error: " 'NoneType' object has no attribute 'get' " when trying to update latest row in Google Sheets with a formula
Best answer

Error: " 'NoneType' object has no attribute 'get' " when trying to update latest row in Google Sheets with a formula

  • 19 January 2023
  • 2 replies
  • 561 views
J

I have a Google Sheet which updates automatically from a Google Form, the most recent entries appearing as a new row at the bottom. Additionally, I have another Zap posting the most recent row as a Slack message. I want one of the columns in my sheet to contain a formula, but if I drag the formula all the way down into currently empty rows, the Zap that posts to Slack won’t work.

 

To get around this, I’m trying to make my new Zap find the most recently updated row in the sheet, and fill in the correct cell with the formula (which also has to reference the recently-created row). All the steps look fine, until I test the action and get the error message in the title. I’m sure that the form is updating to the sheet correctly, and Zapier is able to find the row I want to edit correctly. Anyone have any ideas why I could be getting this error? Thanks. 

Screenshots of my Zap: 

 

icon

Best answer by jesse 19 January 2023, 21:05

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.

2 replies

jesse
Userlevel 7
Badge +9

Hey @JMP happy to help here! You’re getting this error because the “Row” field is expecting a “Row ID” but you have a timestamp mapped in there instead. Swapping in the Row ID from the previous step should do the trick. And if it’s helpful, here is a similar thread with another member who ran into the same issue and how they resolved it: 

If you run into any other issues, just let us know - we’re here to help!

J

Hi Jesse, thanks for the help! The error I got originally is resolved, though something else has come up. The way I have the formula that I want inserted into the sheet written out in Zapier produces an error message in the cell instead; if I type the formula in manually on Google Sheets, it works fine. I think this is because the cells being referenced have their data written in dollar format, and when Zapier finds that data and sends it back to the sheet in the formula, it can’t parse it. Is there a way to write out the formula in Zapier just in terms of the cell IDs of the most recent row, instead of the actual data from those cells?

Terms & Conditions