3

You can build a custom parser for any fixed JSON string using regular expressions. For example, if you want to extract the child items into columns you can do the following (assuming your JSON string is in A1): =SPLIT(REGEXREPLACE(INDEX(REGEXEXTRACT(A1,"(\[(\n|\s|""|\w|,)+\])"),1),"(\[|\]|\n|\s|"")",""),",") You can adapt this formula to suit whatever ...


3

You can also fix this without clearing all your cookies if you leave your university (or other "G Suite" accounts)—just delete your Google "Sign In" cookies. In Chrome, you can do this by going to chrome://settings/cookies/detail?site=accounts.google.com&search=cookies and just deleting all cookies on it. You'll have to resign into Google accounts that ...


3

Since Jul. 25th 2019 it's actually possible to specify in which account to create the new file, exactly as you stated in your question. From now on: docs.new/1 - creates the file in your personal account docs.new/2 - creates the file in your second account (if you're signed in) That applies to all .new shortcut URLs, check the explainer video from Google.


3

That probably doesn't answer your problem, but for the record, there is something that looks like symlinks (january 2019), but is not. In particular you can't change the target without recreating the link, which changes its URL. You can create such links from the GDrive web interface by selecting a file and pressing Shift-Z. No idea why they made it so ...


3

There's no way to to this out of the box. I added custom search engine with keyword "yes" and search string javascript:[...document.querySelectorAll('div[role="button"]')].filter(i => i.textContent === 'Yes')[0].click() and named it 'Say "yes" to Google Calendar invitation'. And the other one with keyword "no" and search string javascript:[...document....


2

larsen161 got me where I needed to go. I wanted to exclude a User recipient from the "ALL" mailing group in my domain. I followed larsen161 instructions but I also had to activate the Envelope filter option with: Only affect specific envelope recipients , then in Single email address I added the recipient's email address I wanted to exclude. I also had to ...


2

Use the script editor to store hidden information. You can use comments /* */ to hold the actual information. Make sure and click save when you are done.


1

As mentioned in the example at the official site: Sets the active sheet in a spreadsheet, with the option to restore the most recent selection within that sheet. The Google Sheets UI displays the chosen sheet unless the sheet belongs to a different spreadsheet. // Set the first sheet as the active sheet and select the range D4:F4. spreadsheet....


1

From Sign in to multiple accounts at once What a default account is In many cases, your default account is the one you signed in with first. On mobile devices, your default account can vary depending on your device's operating system and the apps you use. To change the default account, sign out of all your Google accounts then first sign-in by using ...


1

Redirectnator v1.1 is a spreadsheet created by Jeff Louella. It has a function built-in, with server code (301/302/200/404) and final url. You can make a copy here : https://www.thetechseo.com/seo-tools/redirect-checker/ Here's the script you can use/modify : function redirectCheck(url, user, pwd) { try { function getResp(url, user, pwd){ ...


1

Iframes are not allowed in GitHub As stated on the GitHub site here and here, iframes are not allowed in GitHub There may be a workaround though through Zap (may be because I haven't tried it myself). Once you create your Zap account you get to see quite a few triggers. Please give it a try and let us know how it goes.


1

I don't know what happened (AFAIK I haven't changed anything in my Google Account settings for at least months)... Google updates it's algorithms every few months and it seems that the latest updates have caused quite a few issues. There is a number of them mentioned under the official support community Google search uses German, when I have English ...


1

IMPORTHTML doesn't works because the page you are trying to scrape use JavaScript to add the data tables to the page. Google Sheets doesn't have built-in functions that are able to scrape data that is isn't included on the source code. Related How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a ...


1

Several G Suite apps have a setting for G Suite admins to enable/disable the warning, like Hangouts From Hangouts settings Hangouts out of domain warning By enabling this setting, you provide a warning to users when they’re having a Hangout with users of an external domain. As an administrator, this also provides you with more visibility into ...


1

I had a situation to randomly pick M or F in a column. I used this formula in Google Sheets: =IF(RANDBETWEEN(1,2) = 1,"M","F") Crude way, certainly not for long lists, but it works if your set of values is small.


1

You can write a simple python code to extract the zip-file directly in your Google Drive from Google Colab. Note: For this code to work, you'll need to install a module named rarfile in Colab. You can do so by the following code snippet: pip install rarfile Without getting into the details of how it works, go ahead and copy the code snippet below into ...


1

I don't know if this existed at the time, but you can add versions to uploaded files. Right click the uploaded file in google docs Click "Manage Versions" Click "Upload New Version" Select the new resume file


1

Since this is still an issue in 2019, below is the link I used to enable YouTube for an old Google Apps (Free) account. https://admin.google.com/ac/settings/serviceonoff?iid=118


1

In addition to @Charlie Stevensons answer, the errors can be suppressed and only output the name of the calendar for those who actually have calendars. $list = gam.exe print users foreach ($entry in $list) { if ($entry -eq "Email") { continue } $summary = gam.exe user $entry show calendars 2>&1 | Select-String -...


Only top voted, non community-wiki answers of a minimum length are eligible