Profile cover photo
Profile photo
Romain Vialard
8,002 followers -
Google Developer Expert, Google Top Contributor, Change Management consultant & Pre Sales Engineer
Google Developer Expert, Google Top Contributor, Change Management consultant & Pre Sales Engineer

8,002 followers
About
Posts

Post has shared content
In the FirebaseApp library, you can now use Google OAuth2 access tokens generated from a service account.

This means there are now 3 ways to make authenticated calls with FirebaseApp:
- via a Firebase app secret (legacy token)
- via the access token retrieved with ScriptApp.getOAuthToken()
- via an access token generated using a Service Account

If your script is deployed as an add-on or a web app executed by the user, this is the recommended way to make calls to the Firebase Realtime Database from server side functions.

No real changes in the FirebaseApp library, Google OAuth2 access tokens were already supported. This tutorial relies on the OAuth2 library from +Eric Koleda to handle the service account authorization flow and provide to FirebaseApp a valid access token.

Post has attachment
In the FirebaseApp library, you can now use Google OAuth2 access tokens generated from a service account.

This means there are now 3 ways to make authenticated calls with FirebaseApp:
- via a Firebase app secret (legacy token)
- via the access token retrieved with ScriptApp.getOAuthToken()
- via an access token generated using a Service Account

If your script is deployed as an add-on or a web app executed by the user, this is the recommended way to make calls to the Firebase Realtime Database from server side functions.

No real changes in the FirebaseApp library, Google OAuth2 access tokens were already supported. This tutorial relies on the OAuth2 library from +Eric Koleda to handle the service account authorization flow and provide to FirebaseApp a valid access token.

Post has attachment
I've updated the PicasaApp library (Apps Script connector to Google Photos) to leverage the new oauth flow brought by the Apps Script manifest.
https://sites.google.com/site/scriptsexamples/new-connectors-to-google-services/picasa-services

It means there's no need anymore to do any complex additional oauth step to access the Picasa Web Album API from the library. You simply add the lib to your script and next time your run a function it will ask the new permission ("manage your photos and videos") like you are used to.

This means that when your update the scopes in the manifest of a library, any script using this library will correctly detect the required scopes from the library's manifest!
https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes
Animated Photo

Post has attachment
Great new "Month in review" email from Google Maps, summarizing your recent trips and places you visited.
Animated Photo

Post has attachment
300+ upvotes and nearly 50 very nice reviews so far for Yet Another Mail Merge on Product Hunt!
Many thanks to all of you for helping us promote YAMM to new users!

Post has shared content
We have updated our FirebaseApp library to support authentication via an Apps Script OAuth 2 access token (instead of using a service account or a legacy token).

You can use the default Apps Script authentication to connect to your Firebase database as an admin. This authentication method is only recommended for scripts running as yourself, not for add-ons or Apps Script web apps executed by end users.

You simply need to update your manifest file in Apps Script to add the Firebase Database authorization scope:
https://www.googleapis.com/auth/firebase.database

Post has attachment
We have updated our FirebaseApp library to support authentication via an Apps Script OAuth 2 access token (instead of using a service account or a legacy token).

You can use the default Apps Script authentication to connect to your Firebase database as an admin. This authentication method is only recommended for scripts running as yourself, not for add-ons or Apps Script web apps executed by end users.

You simply need to update your manifest file in Apps Script to add the Firebase Database authorization scope:
https://www.googleapis.com/auth/firebase.database

Post has shared content
Our add-on for Google Slides, Photo Slideshow uses the new Apps Script Manifest and the ability to set Authorization Scopes explicitly to connect to the Picasa / Google Photos API, without having to rely on an additional OAuth flow.

https://chrome.google.com/webstore/detail/photo-slideshow/llgeanpccblagafdmfalehmopdbakhol?utm_source=permalink
https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes

Photo Slideshow lets you import images from either a Google Drive folder or a Google Photos album, and display them as slides in a Google presentation.

You can explicitly set the scopes your script project uses by editing its manifest file.
There's no connector to Picasa / Google Photos in Apps Script but there's an API:
https://developers.google.com/picasa-web/
And a specific scope you can add in your manifest file in Apps Script:
https://www.googleapis.com/auth/photos
Photo

Post has attachment
Our add-on for Google Slides, Photo Slideshow uses the new Apps Script Manifest and the ability to set Authorization Scopes explicitly to connect to the Picasa / Google Photos API, without having to rely on an additional OAuth flow.

https://chrome.google.com/webstore/detail/photo-slideshow/llgeanpccblagafdmfalehmopdbakhol?utm_source=permalink
https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes

Photo Slideshow lets you import images from either a Google Drive folder or a Google Photos album, and display them as slides in a Google presentation.

You can explicitly set the scopes your script project uses by editing its manifest file.
There's no connector to Picasa / Google Photos in Apps Script but there's an API:
https://developers.google.com/picasa-web/
And a specific scope you can add in your manifest file in Apps Script:
https://www.googleapis.com/auth/photos
Photo

Post has attachment
YAMM is trending on Product Hunt, if you like the product, please spread the word :)

Product Hunt is like a social network to share and discover new products. Many startups are using it to launch their product and get their first users. YAMM isn't exactly new (but constantly evolving!) but it's a great way for us to reach new users.
Wait while more posts are being loaded