Channel: Google Workspace

Category: Science & Technology

Description: Add to your calendar and ask your questions in advance here: goo.gle/april-office-hours Join us for AppSheet Office Hours on April 14th at 11AM PT to discover new platform enhancements that greatly enhance app creation with both the new Apps Script integration and BigQuery Connector enhancements coming soon. The AppSheet team will demonstrate how you can natively call Google Apps Script functions within your AppSheet automation workflows, enabling your apps to tightly integrate with your own Apps Script code and over 30 Apps Script services, with support for Google Drive, Sheets, Calendar, Gmail, and more. We’ll also explain how you can use data from BigQuery with the BigQuery Connector, plus new enhancements coming soon. As always, you’ll have the opportunity to ask any questions (even if they’re not directly related to the session topic) and receive answers live from AppSheet experts. 00:00 Welcome 01:07 Apps Script Connector Overview 4:11 Apps Script Demo - building a travel request chatbot in AppSheet 14:25 Apps Script Q&A 18:46 Using Data from BigQuery 22:55 BigQuery Connector demo 33:37 Open Q&A 38:50 BigQuery Connector demo with write access 42:50 Open Q&A 59:34 Resources and what's next Join, learn, and engage with the community → community.appsheet.com Get started with AppSheet → appsheet.com Share your feedback and ideas for future Office Hours → goo.gle/office-hours-feedback