Does anyone have an example of how to use the google photos API in 2023? I’m specifying the year because if I try to search for documentation for this, I end up on a photos.get (from google) with sample code that when I run it, gives me an error that the documented approach is already deprecated: I̵…
Tag: google-api
Youtube API Playlist – List playlist stopped working
I have a strange issue on a system that creates a youtube playlist, and then fills the playlist with videos from a database table. The code is Version Controlled by GIT, and have no commits in the code for 3-4 months, and it has worked up to a couple of days back. Suddenly it can’t find the items, and t…
Google OAuth resulting in server_error
When my window loads I run the following code: After the initialization completes and after the user clicks a sign-in button, I run the following code: I get the following error in my console: error: “server_error” How do I fix this? Answer This code worked for me: HTML JAVASCRIPT
How to send/archive a row of data from one sheet to another through trigger?
I would like for a way to send a row of data from a sheet (Sheet) to another (Sheet Archive). If “Archive” is written in the 2nd column of a row, it sends the data to the archive sheet. I want the data to stack one row after another. Say I archive row #20 in Sheet #1, I want it
How to update data validation for a certain range within a specific column with a master list with Google Apps Script?
I have two sheets, both have a column that use data validation in Column G/#7, starting from row #8 and all the way down. I have to edit the data validation every once in a while and match the lists for both sheets. This can be annoying since it starts from row 8 down to row 1000+ and needs to
Google Drive API: How to create a file in appDataFolder?
I’m reading this documenation: https://developers.google.com/drive/api/v3/appdata This is my code: I get a 403 error: “The user does not have sufficient permissions for this file.” Does not the user have permission to create a file in his appDataFolder? How to create a file in it? The scope …
Create tree from 2D array and update Google Sheet
I’m trying to create a tree view (and dump that into a Google sheet) of our OrgUnits. I have the following script which pulls and sorts the data: The above code produces the array called ouArray, which looks like this: Now what I want to do is take that data, and format it and place it into a Google She…
What’s the correct way to make the uploaded image file accessible via URL – google drive api v3
I have created a project on Google API’s developer console and enabled Google Drive API. As well as I have created and downloaded Service account credentials .json file which I am using on Node.js backend server and connecting and uploading image files on google drive. When I upload the file I get the u…
Google Sheets API v4 write data
I am trying to write data to a Google Sheet using the Nodejs API v4. I can sucessfully read and clear data, so I have set everything up correctly. However, using the example in the docs here for the update method, I cannot work out how to specify the data I want to put in the Google sheet. I would
How to check if user is logged in or not with “Google Sign In” (OAuth 2.0)
I am implementing Google log in for the first time as described here and here. I am using HTML with Javascript. The problem that needs solving is as follows: How can I, after the initial login, on a different page (say a landing page, or portal that the user sees after logging in), check if the user is logged…