I’m working on internal google sites to host all the product, projects & customer related content for my company to avail accessibility for sales & support teams.
– The data is hosted as per different regions for all the customers – each with their own subpage.
– All the pages are based on one template. We’re talking about 1500-3000 such pages.
– Certain data on the pages, is rendered via html embed feature, where I’ve defined constants to populate the html tables.
– The data in these tables will keep changing as per future iterations. eg, when a customer’s spoc details change, the team member will update the same in the site page.

What I couldn’t find a working way to achieve is:

- Export the data from site pages to google bigquery (ETL Pipeline)

I’ve found multiple forums, blogs & video tutorials regarding integrating Analytical data from bigquery to sites but not the other way around, which brings me here seeking the help.

It’d be great if any advice in this regard

[google-bigquery] [google-sites]

Tried appscripts to export in a sheet and than create an ETL, but export to sheet has it’s own set of problems.