Hi all, I m trying to use the YouTube api from Appsheet to retrieve a friendlier url. I looked at this page https://developers.google.com/youtube/v3/docs/videos/list and they suggest to redirect questions on stackoverflow. See my post: https://stackoverflow.com/questions/64940134/how-to-capture-th…

There’s some manual work to do this. Create an action in the detail view of type ‘External: Go to a website’ and put this as the URL to go to: CONCATENATE(“[ https://us-central1-able3api.cloudfunctions.net/youtubeshorturl?url=https://www.youtube.com/watch_videos?video_ids=“,[Related](https://us-cent…

Thank you When you click the action, it should give you the short URL. Add a real column to the sheet and copy and paste it into the relevant cell. This is not going to be convenient since users are generating dynamically the id list. Automatic population to a cell is doable with an app script…

I initially tried to do it using app script but it doesn’t support the HEAD method so I wrote a Python function and deployed it as a Google Cloud Function. If you need the code fragment that does the job, let me know and I will post it.

That would be very appreciated. Thank you I use google app script to retrieve the video duration. Works very well! Found the script here: https://stackoverflow.com/questions/51561919/google-sheet-formula-to-convert-youtubes-api-iso-8601-duration-format

Here is the google app script you will need. Note that you will have to pass the list of IDs in the JSON payload from the AppSheet webhook and also replace the Logger.log() line with the code to write the value to the correct cell. function doPost (e) { var json = e.postData.contents; var b…

you will have to pass the list of IDs in the JSON payload from the AppSheet webhook and also replace the Logger.log() line with the code to write the value to the correct cell. Sorry I don’t know what that means. Can’t I use this function the same way i use this one to retrieve the YouTube video…

Yes, you could certainly do that.

Works great. Thank you! function getYoutubeListId3(e){ var params = {"method" : "GET"}; var response = UrlFetchApp.fetch('https://us-central1-able3api.cloudfunctions.net/youtubeshorturl?url=https://www.youtube.com/watch_videos?video_ids='+e, params); var code = response.getResponseCode() …

I don’t know why I can’t access the cloud function page… Need to reach out to google support. [3X_6_1_61b7f9923cd10b60230f5cfd42d41b40417388bb.png]

@teambelair You can’t reach the google function codepage as it’s owned by ABLE3 domain’s cloud account. Bellave_Jayaram: There’s some manual work to do this. Create an action in the detail view of type ‘External: Go to a website’ and put this as the URL to go to:> > CONCATENATE(“[ https://us-cent…

Webhook Youtube api

AppSheet AppSheet Q&A

anonymous8 November 22, 2020, 3:37pm 19

I don’t know why I can’t access the cloud function page… Need to reach out to google support.

Topic		Replies	Views
Webhook QR code AppSheet Q&A admin , intelligence , automation , other , resources , databases , expressions	3	11	May 26, 2022
Web Hook Return Value AppSheet Q&A automation	9	22	June 18, 2021
Two ways to shorten URL in-app Tips & Tricks admin , expressions	8	435	July 2, 2025

Webhook Youtube api

AI Suggested topics