This video shows how to use Google Docs/Sheet extension made with Google App Script to extract hyperlinks or URLs of multiple files stored inside a Google Drive folder.
When querying and embedding image files in Google Looker Studio, the URL must be altered to redirect to the image file instead of the Google Drive file preview page.
Google Sheet template with AppScript code: lynk.id/geografif/7RakZ61
Also watch: • Looker Studio: Display...
_________________________________________________________
Video ini menunjukkan cara menggunakan ekstensi Google Docs/Sheet yang dibuat dengan Google App Script untuk mengekstrak hyperlink/URL beberapa file di dalam folder Google Drive.
Jika Anda membuat kueri dan menyematkan file gambar di Google Looker Studio, URL perlu diubah agar dialihkan ke file gambar, bukan halaman pratinjau file Google Drive.
Template Google Sheet dengan kode AppScript: lynk.id/geografif/7RakZ61
Tonton juga: • Looker Studio: Display...
Негізгі бет Ғылым және технология Extract hyperlinks of files In Google Drive folder to Google Sheet automatically | App Script
Пікірлер: 2