Finally got the Human-Google-Sheets-SheetDB-Wordpress-ACF-Elementor-Templates Centipede working, and similar to its namesake, I am relieved that it’s over.
Posting this partly for my own memory in the future, when I need to make updates, partly because it may be of use to others.