You have to get an access to UI. For an example SpreadsheetApp.getUi().showModelessDialog ... After this call window.open then google.script.host.close(); if you need.
The example https://docs.google.com/spreadsheets/d/1Q9VFiCrbwLwqm5i2y8OJU4RsSuj8qUhocqd1YUzR1p0/copy
| // Unfollow in batch | |
| async function unfollow() { | |
| // Retrieve all followings | |
| window.following = document.querySelectorAll("[role='button'] .css-901oao.css-16my406.r-poiln3.r-bcqeeo.r-qvutc0") | |
| window.waitFor = function (ms) { return new Promise(function(resolve) { setTimeout(resolve, ms) } ) } | |
| let counter = 0; | |
| // Loop through followings | |
| for (let i = 0; i < following.length; i++) { |
| --- | |
| layout: null | |
| title: "Feed title (e.g. John Doe's Blog)" | |
| author: "Site name (e.g. John Doe)" | |
| website: "http://example.org" | |
| --- | |
| <?xml version="1.0" encoding="utf-8"?> | |
| <feed xmlns="http://www.w3.org/2005/Atom"> | |
| <template> | |
| <svg class="sparkline" :width="width" :height="height" :stroke-width="stroke"> | |
| <path class="sparkline--line" :d="shape" fill="none"></path> | |
| <path | |
| class="sparkline--fill" | |
| :d="[shape, fillEndPath].join(' ')" | |
| stroke="none" | |
| ></path> | |
| </svg> | |
| </template> |
| function sendEmails() { | |
| const recipients = ["sally@mailmeteor.com", "neil@mailmeteor.com"]; | |
| const template = { | |
| "subject": "My mail merge script for Gmail", | |
| "content": `Hi,<br><br> | |
| I just wanted to show you how to send emails in bulk with my Gmail account!<br><br> | |
| Take care,<br> |
Hello {{ firstname }},
I'm glad we could meet lately. As discussed, we are using a brand new mail merge solution called Mailmeteor.
Mailmeteor lets you send hundreds of personalized emails, right from Gmail.
I’d love to let you see some of the features to get your feedback. We want to ensure Mailmeteor would actually help you do your job better at {{ company }}.
Would you have 10-15 minutes free to chat? (I promise to keep the time!). Let me know the time that suits you best.
| const axios = require("axios"); | |
| const authId = "aa4041d0-xxx-xxx-xxxxxx-xxxxxx"; | |
| const setupId = "45f63608-xxx-xxx-xxxxxx-xxxxxx"; | |
| const authUrl = `https://auth.bearer.sh/apis/typeform/auth/${authId}`; | |
| const pizzlySecretKey = 'secure-secret-key' | |
| const pizzlyAuthenticationHeader = 'Basic ' + Buffer.from(pizzlySecretKey + ':').toString('base64') | |
| axios |
| // Handle retries when calling Apps Script functions, | |
| // from the client-side (i.e. a browser). | |
| // | |
| // @usage: | |
| // - google.script.run.withRetry().myFunction() // Will retry "myFunction" 2 times | |
| // - google.script.run.withRetry(5).myFunction() // Will retry "myFunction" 5 times | |
| // | |
| // /!\ Known caveats. The method withUserObject(object) is not supported. | |
| if (google && google.script && google.script.run) { |
Steps to reproduce:
Steps to reproduce:
00:00 - Sign in to Google Cloud Console
00:30 - Grab or create your OAuth2.0 credentials
03:20 - Make sure you've enabled the Google Sheets API - https://console.cloud.google.com/apis/api/sheets.googleapis.com/overview
03:35 - Preparing the Google Sheets Integration
