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.

  • Home
  • Get Help
  • How Do I
  • How do I automatically update a spreadsheet with digital invoice data for inventory management using Zapier?

Hey guys im trying to figure out how i can use digital invoices sent to me through email as data to log onto a spread sheet for example:

Imagine the invoice says that i bought 10 4x4x8 for this price and 10 6x6x8 for this price how can i log this data onto a spreadsheet and add that number to exsisting stock of 4x4x8 and 6x6x8.

so if i already have 10 4x4x8 and the company buys another 10 4x4x8 it auto updates on the sheet to 20 4x4x8, This would be scaled up to a variety of lumber sizes of course but having a hard time figuring out how to do this.

any feedback will help!

 

Hi @Christian Silva 

Which spreadsheet app are you trying to use? (e.g. GSheets)

If the Invoices are PDFs, then you’d likely have to parse the PDFs using a PDF parsing app.

Check apps that handle documents here: https://zapier.com/apps/categories/documents

Google sheets is what id be trying to use

 

@Christian Silva 

GSheets Zap app available triggers/actions: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

Concept is to find a matching row, then update the row with the new values after performing a calculation.

 

Action: Formatter > Numbers > Perform Math Operation

Can be use to do math (add, subtract, multiply, divide)

 

To handle line items from the invoices, you can use the Looping app: https://zapier.com/apps/looping/help

So i was able to use a google drive Trigger to Parse the pdf with pdf.co My issue now is essentially a google sheets problem,

 

How would i be able to take the info I have and use the qty data to update my exsisting qty number on the stock lumber page with the matching item

 

 

@Christian Silva 

That depends on how the data is returned from PDF.co in the Zap step. (screenshots)

 

Concept is to find a matching row, then update the row with the new values after performing a calculation.

 

Action: Formatter > Numbers > Perform Math Operation

Can be use to do math (add, subtract, multiply, divide)

 

To handle line items from the invoices, you can use the Looping app: https://zapier.com/apps/looping/help

Terms & Conditions