{"id":28069,"date":"2020-08-15T21:23:52","date_gmt":"2020-08-15T13:23:52","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=28069"},"modified":"2020-08-14T17:33:36","modified_gmt":"2020-08-14T09:33:36","slug":"google-drive-google-apps-scripts","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/","title":{"rendered":"19 Useful Google Apps Scripts to Automate Google Drive"},"content":{"rendered":"<p>Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work. Google Apps Scripts is an easy-to-use scripting language to <strong>get things done<\/strong>, which are otherwise not available in Drive.<\/p>\n<p>There are scripts that can let you read\/extract text from images, convert files, auto-backup social photos or store Gmail attachments. Most scripts let you automate these services as well.<\/p>\n<p>Let\u2019s check out how to make use of Google Apps Scripts to <strong>fill the missing holes<\/strong> in Google Drive and do many more things without third-party tools.<\/p>\n<div class=\"ref-block ref-block--post\" id=\"ref-post-1\">\n\t\t\t\t\t<a href=\"https:\/\/www.hongkiat.com\/blog\/apps-to-automate-android\/\" class=\"ref-block__link\" title=\"Read More: 5 Free Android Apps to Automate Tasks\" rel=\"bookmark\"><span class=\"screen-reader-text\">5 Free Android Apps to Automate Tasks<\/span><\/a>\n<div class=\"ref-block__thumbnail img-thumb img-thumb--jumbo\" data-img='{ \"src\" : \"https:\/\/assets.hongkiat.com\/uploads\/thumbs\/250x160\/apps-to-automate-android.jpg\" }'>\n\t\t\t\t\t\t\t<noscript>\n<style>.no-js #ref-block-post-19628 .ref-block__thumbnail { background-image: url(\"https:\/\/assets.hongkiat.com\/uploads\/thumbs\/250x160\/apps-to-automate-android.jpg\"); }<\/style>\n<\/noscript>\n\t\t\t\t\t\t<\/div>\n<div class=\"ref-block__summary\">\n<h4 class=\"ref-title\">5 Free Android Apps to Automate Tasks<\/h4>\n<p class=\"ref-description\">\n\t\t\t\t\t\tOne thing most people love about Android is the freedom to create that is open source identity affords...\t\t\t\t\t\t<span>Read more<\/span><\/p>\n<\/div>\n<\/div>\n<h2>How to Run Google Apps Scripts<\/h2>\n<p>To create and run a script in Drive, follow these steps:<\/p>\n<ol>\n<li>Create\/open a Google Doc or Sheet. From <strong>Tools<\/strong> menu, select <strong>Script editor<\/strong>.<\/li>\n<li>Remove existing code and add your code. Go to <strong>File<\/strong> &gt; <strong>Save<\/strong> &gt; add script name &gt; Click <strong>OK<\/strong>.<\/li>\n<li>To execute, click \u25ba, or from the <strong>Run<\/strong> menu, select a function. If running the script for first time, it will ask for your authentication. Check the required permissions and click <em>Allow<\/em>.<\/li>\n<li>A yellow bar will appear at the centre-top, to indicate that the script is running.<\/li>\n<\/ol>\n<p>Please note these steps are for general scripts and certain scripts may require specific additional instructions to run.<\/p>\n<h3>1. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/ctrlq.org\/code\/19869-email-google-spreadsheets-pdf\">Convert and Email Google Sheets<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Converts <strong>Google Sheets to<\/strong> PDF and <strong>mails them<\/strong> using your Gmail account<\/li>\n<li>Lets you <strong>convert and send just one sheet<\/strong> using its sheet id.<\/li>\n<li>Send the PDF to <strong>multiple persons<\/strong> by adding their addresses, separated by commas.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>It\u2019s helpful in scenarios like when you wish to send marketing data to a third party but don\u2019t want to share the whole spreadsheet. You can use this script to send a PDF version. This way required data is shared without compromising your whole spreadsheet\u2019s info.<\/p>\n<h3>2. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/tagplus5\/07dde5ca61fe8f42045d\">Convert Images to Text using OCR<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Converts images to text<\/strong> documents using the OCR technology; saves them in your drive. <\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This script proves beneficial in situations when you need to edit text in imges or do research on a large number of images. It makes the converted images editable and searchable. It saves your time and efforts and gives trustworthy text output as it uses the Google\u2019s native OCR technology.<\/p>\n<h3>3. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/ctrlq.org\/code\/20060-monitor-file-changes-in-drive\">Track File Editors in Google Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Finds out which user made changes to your Google Drive\u2019s native files. <\/li>\n<li>Displays the dates and times when the file was modified <strong>along with the name and email address<\/strong> of users who made the changes to your shared documents\/files.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This script is useful for tracking the modifications made in your drive, including Sheets, Documents, Presentations and other Google Drive formats.<\/p>\n<h3>4. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/github.com\/hijonathan\/google-scripts\/blob\/master\/backup-url.js\">Save a Webpage to Google Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Saves or backs up webpage<\/strong> on any URL to Google Drive.<\/li>\n<li>Fetches the web page and <strong>saves the same as HTML<\/strong> file (by default) or your configured extension.<\/li>\n<li>Maintains a nice <strong>folder structure<\/strong> for storing multiple web pages or their copies.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This script is most helpful for researchers, scholars, bloggers and such who need to research lots of websites and might need to save them for future reference. Do remember to change the <em>RESOURCE_URL<\/em> in the snippet to the link you wish to download.<\/p>\n<h3>5. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/erickoledadevrel\/11143648\">Send a Google Doc via Email<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Sends a Google Doc through email to anyone and places the <strong>doc\u2019s content as the email\u2019s body<\/strong> (rather than an attachment).<\/li>\n<li>Converts the <strong>doc to HTML<\/strong> and sends the same via email<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>If you want to send something not as an attachment but as part of the email, this is the that gets the job done. Do note you must change <em>documentId, recipient, subject<\/em> to their actual values in the 4th line.<\/p>\n<h3>6. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/www.labnol.org\/internet\/host-website-on-google-drive\/28178\/\">Host a Website on Google Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Host any static website<\/strong> including files like HTML, CSS, JS, image, podcast, etc on Google Drive. (Drive can\u2019t be used to serve dynamic sites like those using PHP or Java backends.)<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This script is useful when you don\u2019t wish to buy a hosting plan or domain for your site. It\u2019s completely free of charge and Google\u2019s servers are a lot faster than many hosting providers in the world.<\/p>\n<h3>7. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/sites.google.com\/site\/appsscripttutorial\/home\/downloading-instagram-photos-to-your-google-drive-using-google-apps-script\">Download Instagram Photos to Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Downloads <strong>multiple Instagram photos<\/strong> and save them to your drive automatically. <\/li>\n<li><strong>Download photos using certain tags<\/strong> or from any specific Instagram URL.<\/li>\n<li>Images are kept in a separate folder in Drive for easy maintenance.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>It\u2019s helpful for Instagram fans, collectors and researchers who maintain data backups in Drive.<\/p>\n<h3>8. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/github.com\/mangini\/gdocs2md\">Convert a <\/a><a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/github.com\/mangini\/gdocs2md\">Google Doc<\/a><a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/github.com\/mangini\/gdocs2md\"> to Markdown<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Converts a Google Doc to the <strong>markdown (.md) format<\/strong>.<\/li>\n<li>It mails you the converted document along with images automatically. (Note it may get into problems with data using complex formatting.)<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>It\u2019s useful for bloggers and publishers who regularly use the markdown format for publishing online. Using this, they can avoid manual work of converting their content for every draft.<\/p>\n<h3>9. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/www.labnol.org\/internet\/auto-expire-google-drive-links\/27509\/\">Set Auto-Expiry for Shared Data<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Sets an auto-expiry<\/strong> interval on the shared files and folders in Drive<\/li>\n<li>Automatically <strong>removes access to other users<\/strong> after the certain period (of auto-expiry).<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This script is useful for allowing limited access to your drive\u2019s data and relieves you from worrying about forgetting to unshare data. This feature is already available for <em>Google Apps for Work<\/em> users, but if you\u2019re free user, then it\u2019s for you.<\/p>\n<h3>10. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"http:\/\/www.googleappsscript.org\/home\/fetch-gmail-attachment-to-google-drive-using-google-apps-script\">Save Gmail Attachments in Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Extracts and <strong>saves all Gmail attachments to a particular folder<\/strong> in your drive.<\/li>\n<li><strong>Notify progress <\/strong> of fetched attachments, via email but requires setting up notification preferences.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>If you prefer to store attachments into cloud storages like Drive, then this is the script to get.<\/p>\n<h3>11. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/www.labnol.org\/code\/19982-search-files-in-google-drive\">Search All Files in Google Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Searches all your files<\/strong> in the drive and displays the results in simple-to-digest style in a Google Sheet.<\/li>\n<li>Supports docs, sheets, presentations and few other text formats.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>Search through your files and piles of data quickly with this.<\/p>\n<h3>12. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/mesgarpour\/07317e81e9ee2b3f1699\">List Directory in Google Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Lists all <strong>files and folders<\/strong> of a Google Drive\u2019s <strong>directory<\/strong> recursively<\/li>\n<li>Write this data in easy-to-see format in a spreadsheet.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>Good for making sense of all the data in your Drive, and for file management purposes. Do note that for this script to work, you must set the <em>folderId<\/em> first in the code. A folder id is everything after the \u2018<em>folders\/<\/em>\u2018 portion of a folder\u2019s address.<\/p>\n<h3>13. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/soundTricker\/4688073\">Convert Google Docs to HTML<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Converts <strong>Google Docs to HTML format<\/strong> for easy sharing or using in web pages or source code editors.<\/li>\n<li>Supports various basic HTML tags or formatting options but do understand it doesn\u2019t work very well for complex text formatting.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>Helpful mostly for writers, bloggers and publishers seeking posts for HTML-ready tools. Do remember to set the <em>KEY and FILE_ID<\/em> variables in the code.<\/p>\n<h3>14. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/mhawksey\/2252211\">Combine Data from Multiple Sheets<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Merges data from <strong>multiple sheets of a particular spreadsheet<\/strong> into a single sheet in the current spreadsheet.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This script is helpful in situations wherein you have got multiple sheets of common data (including common headers and structure) and you wish to combine them into one large sheet of data.<\/p>\n<h3>15. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/mderazon\/9655893\">Export Google Sheets to CSV Files<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Exports sheets in the current spreadsheet as <strong>individual CSV files<\/strong> in Drive.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>It\u2019s helpful for people who regularly use Sheets for managing and storing data and require data in CSV format for sharing or use in other apps. Without this, Google Sheets only convert and download one sheet at a time.<\/p>\n<p>After copying code into the Script Editor, re-open that spreadsheet and check the <strong>Add-ons<\/strong> menu.<\/p>\n<h3>16. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/gregorynicholas\/9008572\">Convert a Google Sheet to PDF Invoice<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Converts any particular sheet to a <strong>PDF invoice<\/strong> and save to your Drive.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>Good for users who regularly use the Google Apps ecosystem as their work tool and have to deal with product invoices and such.<\/p>\n<h3>17. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/denilsonsa\/8134679\">Upload a URL directly to Google Drive<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Uploads any individual file<\/strong> (or multiple files) <strong>from a specific URL<\/strong> to your drive automatically.<\/li>\n<li><strong>Files are saved in a specific folder<\/strong> in the drive and it can easily upload multiple files from multiple links provided it\u2019s given one at a time.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>For people who like to keep data from the Web in Drive. All it needs is the link of the page you need. To use, copy code into the Script Editor and go to <strong>Publish<\/strong> &gt; <strong>Deploy as web app\u2026<\/strong><\/p>\n<h3>18. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/printminion\/1919613\">Download Google+ Profiles to Google Sheets<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li><strong>Fetches publicly available Google+ profiles\u2019 data<\/strong> to a Google Sheet. The fetched data includes <strong>name, work info, profile picture<\/strong> and more.<\/li>\n<li>The only input it requires is the profile id of the person you wish to get data about and this works for multiple profiles.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>This is extremely helpful for data entry and social media analysts for data collection.<\/p>\n<h3>19. <a target=\"_blank\" rel=\"nofollow noopener noreferrer\" href=\"https:\/\/gist.github.com\/mogsdad\/e6795e438615d252584f\">Convert PDF Attachments to Plain Text<\/a><\/h3>\n<p><strong>What it does:<\/strong><\/p>\n<ul>\n<li>Converts all <strong>PDF<\/strong> attachments from Gmail to <strong>plain text format<\/strong> for easy sharing\/storing<\/li>\n<li>You can <strong>specify the PDF\u2019s original language<\/strong> (for extracting the text) and <strong>save the output plain text files <\/strong>along with the<strong> original PDF<\/strong> files in Google Drive.<\/li>\n<\/ul>\n<p><strong>Use Case Scenario:<\/strong><\/p>\n<p>You regularly receive PDFs via mails and want to save them in Drive in original or plain text form. It does the job in batches.<\/p>\n<p>How did you find this list? Do you know any more Google Apps Scripts which help ease life of a Drive user? Please let us know using the comments section below.<\/p>","protected":false},"excerpt":{"rendered":"<p>Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work. Google Apps Scripts is an easy-to-use scripting language to get things done, which are otherwise not available in Drive. There are scripts that can let you read\/extract text from&hellip;<\/p>\n","protected":false},"author":120,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3398],"tags":[2001],"topic":[4521],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>19 Useful Google Apps Scripts to Automate Google Drive - Hongkiat<\/title>\n<meta name=\"description\" content=\"Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"19 Useful Google Apps Scripts to Automate Google Drive\" \/>\n<meta property=\"og:description\" content=\"Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-15T13:23:52+00:00\" \/>\n<meta name=\"author\" content=\"Ashutosh KS\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ashutosh KS\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/\"},\"author\":{\"name\":\"Ashutosh KS\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/0c0611010da9a578caa32a34232cf7bd\"},\"headline\":\"19 Useful Google Apps Scripts to Automate Google Drive\",\"datePublished\":\"2020-08-15T13:23:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/\"},\"wordCount\":1658,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"keywords\":[\"Google Drive\"],\"articleSection\":[\"Internet\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/\",\"name\":\"19 Useful Google Apps Scripts to Automate Google Drive - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"datePublished\":\"2020-08-15T13:23:52+00:00\",\"description\":\"Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-drive-google-apps-scripts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"19 Useful Google Apps Scripts to Automate Google Drive\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/0c0611010da9a578caa32a34232cf7bd\",\"name\":\"Ashutosh KS\",\"description\":\"Ashutosh is a writer, entrepreneur, and a tech evangelist with expertise in the area of Computer Programming.\",\"sameAs\":[\"https:\\\/\\\/www.hongkiat.com\\\/\"],\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/ashutosh_ks\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"19 Useful Google Apps Scripts to Automate Google Drive - Hongkiat","description":"Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/","og_locale":"en_US","og_type":"article","og_title":"19 Useful Google Apps Scripts to Automate Google Drive","og_description":"Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work.","og_url":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2020-08-15T13:23:52+00:00","author":"Ashutosh KS","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Ashutosh KS","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/"},"author":{"name":"Ashutosh KS","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/0c0611010da9a578caa32a34232cf7bd"},"headline":"19 Useful Google Apps Scripts to Automate Google Drive","datePublished":"2020-08-15T13:23:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/"},"wordCount":1658,"commentCount":2,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"keywords":["Google Drive"],"articleSection":["Internet"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/","url":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/","name":"19 Useful Google Apps Scripts to Automate Google Drive - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"datePublished":"2020-08-15T13:23:52+00:00","description":"Google Drive offers great features for storing and working with different types of files but it does lack some features that are crucial for your work.","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/google-drive-google-apps-scripts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"19 Useful Google Apps Scripts to Automate Google Drive"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/0c0611010da9a578caa32a34232cf7bd","name":"Ashutosh KS","description":"Ashutosh is a writer, entrepreneur, and a tech evangelist with expertise in the area of Computer Programming.","sameAs":["https:\/\/www.hongkiat.com\/"],"url":"https:\/\/www.hongkiat.com\/blog\/author\/ashutosh_ks\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-7iJ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/28069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/120"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=28069"}],"version-history":[{"count":3,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/28069\/revisions"}],"predecessor-version":[{"id":52184,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/28069\/revisions\/52184"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=28069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=28069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=28069"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=28069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}