{"id":934,"date":"2014-03-24T21:16:21","date_gmt":"2014-03-24T15:46:21","guid":{"rendered":"http:\/\/reliablesoftwares.com\/blog\/?p=934"},"modified":"2014-04-02T12:30:01","modified_gmt":"2014-04-02T07:00:01","slug":"schedule-email-messages-gmail-google-sheet","status":"publish","type":"post","link":"http:\/\/reliablesoftwares.com\/blog\/schedule-email-messages-gmail-google-sheet\/","title":{"rendered":"How to Schedule your Email Messages in Gmail with a Google Sheet"},"content":{"rendered":"

\"schedule-gmail-messages\"<\/a><\/p>\n

This script requires you to write your message in Gmail first and save it as a draft. Once that’s done, you can import your drafts into the script and schedule a date and time you would like the email to go out.<\/p>\n

Follow this steps:<\/p>\n

    \n
  1. Create a duplicate of the script here<\/a>.<\/li>\n
  2. Under “Gmail Scheduler” click “Step 1: Authorize”. Select the account you wish to authorize, and log in if necessary.<\/li>\n
  3. Under “Gmail Scheduler” click “Step 2: Fetch messages”. This will pull in everything in your Drafts folder having senders email tagged.<\/li>\n
  4. Double-click the “Scheduled Time” cell next to the email you want to send. You can choose a date there or manually enter the date and time in the following format: m\/dd\/yyyy h:mm:ss.<\/em><\/li>\n
  5. When you’ve chosen all the correct date and times for your emails, select “Schedule Messages” under “Gmail Scheduler.”<\/li>\n
  6. Once email is send the status will changed to Delivered<\/li>\n<\/ol>\n

    Thanks to How to Schedule your Email Messages in Gmail with a Google Sheet<\/a> to show to do it.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    This script requires you to write your message in Gmail first and save it as a draft. Once that’s done,<\/p>\n","protected":false},"author":1,"featured_media":935,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_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},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-934","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-article"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pgLsB5-f4","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3633,"url":"http:\/\/reliablesoftwares.com\/blog\/i-trained-an-ai-on-my-10-years-of-emails-it-learned-to-predict-my-life\/","url_meta":{"origin":934,"position":0},"title":"I Trained an AI on My 10 Years of Emails \u2013 It Learned to Predict My Life","author":"saifuddin","date":"September 18, 2025","format":false,"excerpt":"For years, I wondered: what patterns hide in my own digital footprint? So, I ran an experiment. I took 10 years of my emails, carefully cleaned the data, and trained a local AI model to analyze them. The results were surprising\u2014sometimes funny, sometimes uncomfortably accurate. Here\u2019s what I discovered. \ufe0f\u2026","rel":"","context":"In "AI"","block_context":{"text":"AI","link":"http:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-emails.jpg?fit=1024%2C1024&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-emails.jpg?fit=1024%2C1024&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-emails.jpg?fit=1024%2C1024&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-emails.jpg?fit=1024%2C1024&resize=700%2C400 2x"},"classes":[]},{"id":3642,"url":"http:\/\/reliablesoftwares.com\/blog\/building-a-personal-ai-assistant-that-actually-works-complete-tutorial\/","url_meta":{"origin":934,"position":1},"title":"Building a Personal AI Assistant That Actually Works \u2013 Complete Tutorial","author":"saifuddin","date":"September 25, 2025","format":false,"excerpt":"We\u2019ve all dreamed of having our own J.A.R.V.I.S.\u2014an AI assistant that listens, thinks, and helps us with daily tasks. The good news? You don\u2019t need to spend $1,000+ on a commercial solution. With the right open-source tools, you can build a personal AI assistant for under $50. This tutorial walks\u2026","rel":"","context":"In "AI"","block_context":{"text":"AI","link":"http:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=700%2C400 2x"},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2014\/03\/schedule-gmail-messages.png?fit=950%2C408","_links":{"self":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/comments?post=934"}],"version-history":[{"count":4,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/934\/revisions"}],"predecessor-version":[{"id":943,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/934\/revisions\/943"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/media\/935"}],"wp:attachment":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/media?parent=934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/categories?post=934"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/tags?post=934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}