Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I cannot get beyond the testing step of my zap. This is my first time attempting to create a zap in which a new or updated google sheet record will create an expense transaction in QBO. I have basically hardcoded values for each field and still get “invalid number” or “required param missing”.

Before I spend more days on this, has anyone been successful at implementing this and if so, could share any hints on getting this to work?

TIA!

Hi ​@TSF 

Help us have more info by posting these screenshots:

  • the encountered error in the Zap step
  • how your Zap steps are outlined and configured in EDIT mode with the field mappings visible

Hi ​@TSF,
 
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Hello. Thank you for inquiring about this. Sorry for the delay...I’ve been sick.

I had posted this general question because I wanted to see if anyone has been successful at creating an expense (or cash) transaction in Quickbooks Online and I didn’t want to waste anyone’s time trying to figure it out if its not even possible.  I had emailed zapier support a little while ago and asked about adding the functionality of creating a check entry in QBO and was told that it was not in the QBO API so it’s not possible.  So then I started playing around with creating an expense (not a check) and that’s where I’ve run into so many errors pretty much on every single field in the configuration section and that’s when I started questioning if it’s even possible. 

 

Have you worked with google sheets to create a QBO expense entry (or check)?

 

 

Hi ​@TSF,

 

I'm sorry to hear that you've been unwell and having trouble with creating expenses in QuickBooks Online (QBO) from Google Sheets using Zapier.
You're correct that creating a check entry directly isn't currently supported in the QuickBooks Online API and, therefore, not available as an action in Zapier.

Thank you for confirming what I was told.  

So how does this company (promoted by Intuit) manage to do it? Their technology appears very old!

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

 

 

 

Hi ​@TSF,

 

Older technologies can still be effective if they are reliable, well-suited to a company's needs, and supported by experienced staff. A company promoted by a larger entity like Intuit may offer unique value beyond its technology, such as a strong business model or market position. The best technology depends on a company's needs, resources, and expertise—newer isn't always better.

 

Let us know if you need further assistance. 

Terms & Conditions