Thank you again @ms4446 !I think I have a good news :).I'm currently doing some tests with AppSheet and I've seen that we can now update a table in BigQuery directly via the application, after setting the connection to the table with all the requirem...

Thank you very much @ms4446 for this complete tutorial.So as of today there is no option to create a bigquery native table directly from a google sheet using apps script (with a script creating the bigquery native table) ? I saw that we can also use ...

"a. Utilize Cloud Scheduler to trigger the GCF function at a regular interval (daily, weekly, etc.) that aligns with your data update schedule."How to trigger the GCF when the Google Sheet is edited ?