{"id":3435,"date":"2022-02-17T08:12:28","date_gmt":"2022-02-17T08:12:28","guid":{"rendered":"https:\/\/cocoalopez.com\/blog\/?p=3435"},"modified":"2022-02-17T08:12:32","modified_gmt":"2022-02-17T08:12:32","slug":"how-to-list-google-drive-files-on-a-google-sheet","status":"publish","type":"post","link":"https:\/\/cocoalopez.com\/blog\/?p=3435","title":{"rendered":"How to list Google Drive files on a Google Sheet"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Found a way to run a script that loads all your files for a selected folder onto a google sheet, for comparing versions, checking new updated or added files, etc&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"458\" data-attachment-id=\"3436\" data-permalink=\"https:\/\/cocoalopez.com\/blog\/?attachment_id=3436\" data-orig-file=\"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?fit=872%2C624&amp;ssl=1\" data-orig-size=\"872,624\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"imagen\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?fit=300%2C215&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?fit=640%2C458&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=640%2C458&#038;ssl=1\" alt=\"\" class=\"wp-image-3436\" srcset=\"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?w=872&amp;ssl=1 872w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=300%2C215&amp;ssl=1 300w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=768%2C550&amp;ssl=1 768w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=520%2C372&amp;ssl=1 520w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=805%2C576&amp;ssl=1 805w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=400%2C286&amp;ssl=1 400w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=696%2C498&amp;ssl=1 696w, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?resize=587%2C420&amp;ssl=1 587w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube\"><div style=\"display: contents;\" >\n<div class=\"youtube-embed\" data-video_id=\"8OghJCld6DY\">\n<div data-mode=\"normal\" data-oembed=\"1\" data-provider=\"youtube\" id=\"arve-youtube-8oghjcld6dy\" class=\"arve\">\n\t<div class=\"arve-inner\">\n\t\t<div class=\"arve-embed arve-embed--has-aspect-ratio\">\n\t\t\t<div class=\"arve-ar\" style=\"padding-top:56.250000%\"><\/div>\n\t\t\t<iframe allow=\"accelerometer &apos;none&apos;;autoplay &apos;none&apos;;bluetooth &apos;none&apos;;browsing-topics &apos;none&apos;;camera &apos;none&apos;;clipboard-read &apos;none&apos;;clipboard-write;display-capture &apos;none&apos;;encrypted-media &apos;none&apos;;gamepad &apos;none&apos;;geolocation &apos;none&apos;;gyroscope &apos;none&apos;;hid &apos;none&apos;;identity-credentials-get &apos;none&apos;;idle-detection &apos;none&apos;;keyboard-map &apos;none&apos;;local-fonts;magnetometer &apos;none&apos;;microphone &apos;none&apos;;midi &apos;none&apos;;otp-credentials &apos;none&apos;;payment &apos;none&apos;;picture-in-picture;publickey-credentials-create &apos;none&apos;;publickey-credentials-get &apos;none&apos;;screen-wake-lock &apos;none&apos;;serial &apos;none&apos;;summarizer &apos;none&apos;;sync-xhr;usb &apos;none&apos;;web-share;window-management &apos;none&apos;;xr-spatial-tracking &apos;none&apos;;\" allowfullscreen=\"\" class=\"arve-iframe fitvidsignore\" credentialless data-arve=\"arve-youtube-8oghjcld6dy\" data-lenis-prevent=\"\" data-src-no-ap=\"https:\/\/www.youtube-nocookie.com\/embed\/8OghJCld6DY?feature=oembed&#038;enablejsapi=1&amp;iv_load_policy=3&amp;modestbranding=1&amp;rel=0&amp;autohide=1&amp;playsinline=0&amp;autoplay=0\" frameborder=\"0\" height=\"0\" loading=\"lazy\" name=\"\" referrerpolicy=\"strict-origin-when-cross-origin\" sandbox=\"allow-scripts allow-same-origin allow-presentation allow-popups allow-popups-to-escape-sandbox\" scrolling=\"no\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/8OghJCld6DY?feature=oembed&#038;enablejsapi=1&#038;iv_load_policy=3&#038;modestbranding=1&#038;rel=0&#038;autohide=1&#038;playsinline=0&#038;autoplay=0\" title=\"\" width=\"0\"><\/iframe>\n\t\t\t\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t\n\t\n\t<script type=\"application\/ld+json\">{\"@context\":\"http:\\\/\\\/schema.org\\\/\",\"@id\":\"https:\\\/\\\/cocoalopez.com\\\/blog\\\/?p=3435#arve-youtube-8oghjcld6dy\",\"type\":\"VideoObject\",\"embedURL\":\"https:\\\/\\\/www.youtube-nocookie.com\\\/embed\\\/8OghJCld6DY?feature=oembed&enablejsapi=1&iv_load_policy=3&modestbranding=1&rel=0&autohide=1&playsinline=0&autoplay=0\"}<\/script>\n\t\n<\/div><\/div>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Tutorial here: <a href=\"https:\/\/ourtechroom.com\/fix\/list-all-googledrive-links-files-folder-to-googlesheet\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/ourtechroom.com\/fix\/list-all-googledrive-links-files-folder-to-googlesheet\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Found a way to run a script that loads all your files for a selected folder onto a google sheet, for comparing versions, checking new updated or added files, etc&#8230; Tutorial here: https:\/\/ourtechroom.com\/fix\/list-all-googledrive-links-files-folder-to-googlesheet\/<\/p>\n","protected":false},"author":1,"featured_media":3436,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"tdm_status":"","tdm_grid_status":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1002,31],"tags":[],"class_list":["post-3435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-tips-y-tutoriales"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/02\/imagen.png?fit=872%2C624&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9XJix-Tp","jetpack-related-posts":[{"id":3849,"url":"https:\/\/cocoalopez.com\/blog\/?p=3849","url_meta":{"origin":3435,"position":0},"title":"Telegram Bot to notify your channel when a Google Sheet Cell has been edited","author":"cgmodeler","date":"December 22, 2022","format":false,"excerpt":"Did this one over an hour to notify me when certain cells change their value and their adjacent values. Change your telegram bot token and Channel ID to make it work. On the google sheets you want to edit add the following code and add a trigger for it that\u2026","rel":"","context":"In &quot;Featured&quot;","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2724,"url":"https:\/\/cocoalopez.com\/blog\/?p=2724","url_meta":{"origin":3435,"position":1},"title":"Seamless Loops and other Code samples","author":"cgmodeler","date":"June 6, 2018","format":false,"excerpt":"http:\/\/hhoppe.com\/#demos \u00a0 Hugues Hoppe Principal Scientist, Google Inc. Email: Web: http:\/\/hhoppe.com\/ New Check out this GitHub repository with C++ source code and demos for many of my 1992-1998 SIGGRAPH papers. See my notes for using math in Microsoft Word, including this cheat sheet. ...","rel":"","context":"In &quot;Featured&quot;","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/06\/seamless-loops-and-other-code-samples.jpg?fit=852%2C480&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/06\/seamless-loops-and-other-code-samples.jpg?fit=852%2C480&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/06\/seamless-loops-and-other-code-samples.jpg?fit=852%2C480&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/06\/seamless-loops-and-other-code-samples.jpg?fit=852%2C480&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2908,"url":"https:\/\/cocoalopez.com\/blog\/?p=2908","url_meta":{"origin":3435,"position":2},"title":"How to fix Adobe installer failed to initialize","author":"cgmodeler","date":"January 24, 2020","format":false,"excerpt":"Just rename this folder \"OOBE\" C:\\Program Files (x86)\\Common Files\\Adobe\\OOBETo C:\\Program Files (x86)\\Common Files\\Adobe\\OOBE _OLD Rerun Installer","rel":"","context":"In &quot;Tips y Tutoriales&quot;","block_context":{"text":"Tips y Tutoriales","link":"https:\/\/cocoalopez.com\/blog\/?cat=31"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3786,"url":"https:\/\/cocoalopez.com\/blog\/?p=3786","url_meta":{"origin":3435,"position":3},"title":"Recover lost files from Buffalo NAS (raid, EXT, XFS, BTRFS, RAW)","author":"cgmodeler","date":"November 1, 2022","format":false,"excerpt":"Well so it's been two years since my NAS cannot connect to the network anymore, the Buffalo support was useless and the NAS is pretty much a brick by now. The two drives are working perfectly so I decided to make a backup out of them however the raid system\u2026","rel":"","context":"In &quot;Featured&quot;","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/11\/image.png?fit=1039%2C546&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/11\/image.png?fit=1039%2C546&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/11\/image.png?fit=1039%2C546&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/11\/image.png?fit=1039%2C546&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2836,"url":"https:\/\/cocoalopez.com\/blog\/?p=2836","url_meta":{"origin":3435,"position":4},"title":"Convert FinalDraft\/CELTX Screenplay PDF to Kindle","author":"cgmodeler","date":"January 3, 2019","format":false,"excerpt":"First: Download \"k2pdfopt\" (alt download)Export your script in PDF format.Open k2pdfopt and import the pdf file (don't worry it won't over write the pdf) Select the following settings all default unless specified here: \"smart line breaks: 0.200\" \"Max Columns 1\" \"re-flow text\" \"erase vertical lines\" \"erase horizontal lines\" \"fast preview\"\u2026","rel":"","context":"In &quot;zapatainvita&quot;","block_context":{"text":"zapatainvita","link":"https:\/\/cocoalopez.com\/blog\/?cat=35"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2019\/01\/convert-finaldraft-celtx-screenplay-pdf-to-kindle.jpg?fit=480%2C360&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":4156,"url":"https:\/\/cocoalopez.com\/blog\/?p=4156","url_meta":{"origin":3435,"position":5},"title":"Download videos from M3U playlist files","author":"cgmodeler","date":"April 24, 2023","format":false,"excerpt":"Little open sourcee software to download from M3U8 and M3U playlist files. This is an m3u8 downloader. Summary Supports: Auto decrypt for AES-128-CBCMaster ListLive stream recording(BETA)Customize HTTP headersAuto merge clips(Binary or ffmpeg)Select save clip by time code or indexNetwork driver on Windows OSAlternative audio\/video trackMux without video trackCustom HTTP proxy\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/cocoalopez.com\/blog\/?cat=1137"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2023\/04\/image.png?fit=1121%2C789&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2023\/04\/image.png?fit=1121%2C789&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2023\/04\/image.png?fit=1121%2C789&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2023\/04\/image.png?fit=1121%2C789&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2023\/04\/image.png?fit=1121%2C789&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3435"}],"version-history":[{"count":1,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3435\/revisions"}],"predecessor-version":[{"id":3437,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3435\/revisions\/3437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/3436"}],"wp:attachment":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}