HOW TO AUTOMATE A SHEET TO POST ON GOOGLE SITES?

396 views
Skip to first unread message

vitor vargas

unread,
Jun 10, 2021, 6:50:20 PM6/10/21
to Google Apps Script Community
Hey, guys, how are you doing?
Ok, I am looking for a method that allows me to build pages on Google Sites through a Sheet automation. For example: I have a Google Forms where people sign in (name, skills, age, city...), then this information goes to a Sheet. So I wanna automate this Sheet to build a page on Google Sites every time someone signs in the forms. Is this possible?

Sanskar Tiwari

unread,
Jun 11, 2021, 12:46:02 AM6/11/21
to Google Apps Script Community
I can figure this our lets connect 

mail me or Messenger, Whatsapp

Clark Lind

unread,
Jun 11, 2021, 7:21:51 AM6/11/21
to Google Apps Script Community
You can do this with Classic sites but not new Google sites (with Apps script) directly. New Google sites doesn't have an API that I know of, and Apps Script can't access the new sites internally either. I would look at a different free hosting service (even github pages) where you can send POST requests to create pages instead of trying to hack new Google sites. 

Or give theindi...@gmail.com a shot, who knows; I don't know everything!

vitor vargas

unread,
Jun 13, 2021, 3:31:37 PM6/13/21
to Google Apps Script Community
Thank you for the answers. I am about to send a contact to The indie. One more thing: Do you know how Awesome Table works? Because this service lets you embed a Sheet App through your Google Sites. Is there a way, then, to convert a Sheet into an app via App Script?

Clark Lind

unread,
Jun 13, 2021, 3:59:53 PM6/13/21
to Google Apps Script Community
Yes, you can build a webapp with Apps Script attached to specific sheet. Basically it provides an html service which you create on the backend with apps script, and is then displayed in the browser.
Reply all
Reply to author
Forward
0 new messages