Work with partitioned table and upload a csv file in BigQuery with Apps Script.
BigQuery is the famous Google database to store huge amount of data and query them fastly. For a recent a project I had to use it for storing some logs so here the code used with Google Apps Script to create the table and load a csv file from Google Drive.
Source: BigQuery create partitioned table and load CSV with Apps Script
In Apps Script you can use the DriveApp service to manage your files and folders, but the methods getColor and setColor do not exist. You can use the drive advanced service to query the API directly but with recent change you will have to activate the Drive API in GCP and will need a GCP project. To have a smooth integration and skip the Google Cloud project creation here is a function to manage Folder color in Apps Script. These functions queries the API directly with UrlFetchApp() service.
Source: Change Google Drive Folder color with Apps Script – Stéphane Giron – Medium
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
Send push notifications to Hangouts Chat users with Apps Script, do not react only to message sent.
Source: Send push message to Hangouts Chat with Apps Script
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
Stéphane Giron provides a useful list of G Suite related beta programs announced at Google Next 19
Source: All Google G Suite Beta programs from Google Next ’19 to Now
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
How to use Google Drive API for Team Drive in Apps Script with specific focus for Administrator of G Suite domain to list Team Drive, view Sharing Settings and more
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
Since this year (2019) Google will have more strict policy regarding the Gmail scope. If in the past for sending notifications we were used to request the Send Email scope to user, now it is less comprehensible and on Google side you will have to provided lot of more details and your application can be rejected. So it become time for thinking to send email as the application and not as the user. Say Hello to RelayApp service
Source: Build your own Mail Service for Apps Script with Glitch & Gmail SMTP relay
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
