Best way to batch update 10,000+ records?

[mattabreu17]

I have an app handles a relatively large amounts of data (10,000+ Records).

We need to batch update a column on. each of these records. Currently, all I have been able to do is run an automation, but this will only work for about 600-1000 records at a time.

Is there a more efficient way of completing this?

[Rifad]

Appsheet API would be faster. https://support.google.com/appsheet/answer/10105398?hl=en 

[Swoopy]

I would do the update on the back-end Google Sheets for this data size using ARRAYFORMULA() & LOOKUP().