Reputation: 87
Just as the title asks, is that possible? Or is there anything I can do to make that happen?
I'm creating a website that grabs information from a google sheet as live content to the website. Is there a way I can make it create a new page from my page template for when a new row is inserted?
Upvotes: -1
Views: 49
Reputation: 373
Yes, you can, You can use the Google Sheets script. But for that, you might need a middleware backend program.
Please follow this google guide to create the project
https://developers.google.com/apps-script/guides/sheets
After you create a script, Please set the trigger to "Change". (This will automatically fire your app method.)
Inside the function, you can call API to your web server. (If you just have a static website you will need a backend program as well.)
Upvotes: 1