Master Automating Invoice Approval Process on Google Sheets

Have you ever been stuck trying to automate your invoice approval process on Google Sheets? You're not alone. Many users have encountered issues when trying to update a specific cell in a Google Sheet, especially when the cell's value comes from a conditional formatting rule. But don't worry, we've got a solution for you.

The Problem

The main objective is to automate the invoice approval process. Once an invoice is received, approval is requested from the corresponding reviewer via the Google Drive file approval feature. The trigger for this scenario is the automated email sent from Google once a file is approved. This email contains the words “Approval complete” and also the file name in the subject line. The goal is to find a specific row within a Google Sheet by matching the file name from the email to the Google Sheet where all the invoices are documented. In this Google Sheet, there is an Approval column which is meant to display the approval status of the document. By default, the cells under this column will display “In Review” and the aim is to automate changing that cell to “Approved” once the document is approved.

The recurring error message seems to be Runtime Error “400: INVALID_ARGUMENT - Unable to parse range: ‘July’!In Review”. The first steps of the scenario work fine without any issues but as soon as the scenario reaches the “Get a Cell” step, the same error message persists.

The Solution

The error lies in the way the data is mapped in the “Get a Cell” section. The correct format for the “Cell” should be K3, K4. To resolve this problem, update the mapping for the “Cell” field accordingly.

Troubleshooting Tips

Is it necessary to have the “List Sheets” step? It's not always necessary, but it can be helpful in some scenarios. As for updating a specific cell, it's usually best to simply update it, especially if the value in the cell is obtained from a conditional formatting rule.

Conclusion

Automating processes can be tricky, but with the right steps and understanding of how to map data correctly, you can easily automate your invoice approval process on Google Sheets. Remember, the key is in correctly mapping the “Cell” field. Happy automating!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.