Скачать с ютуб How to schedule posts on Instagram from Google Sheets 🤯 fast and free automation 🚀 в хорошем качестве

How to schedule posts on Instagram from Google Sheets 🤯 fast and free automation 🚀

Try a free Make(Integromat) account now: https://rebrand.ly/test_integromat Download ready made blueprint here: https://businessautomated.gumroad.com... Tutorial on how to create Instagram content plan using only Google Sheets and Integromat. All you need is a table in Google Sheets and Integromat connected with Instagram. Read more on medium:   / elevate-your-instagram-brand-presence-usin...   Make Free plan allows you to create fully functioning integration scenarios and provides monthly renewable 1000 operations credit. Subscribe to Business Automated for more video automation tutorials 🚀: https://www.youtube.com/c/BusinessAut... By scheduling your Instagram posts inside Google Sheets, you can easily prepare long list of posts ahead of time. Google Sheets allows also for easy collaboration, so you can have your team or partners cooperate on the same document/content plan, without any limiting subscriptions. Just share your Google Sheet and ask your collaborators to review the content. Once the content is marked "Ready" it is good to be posted on Instagram using Integromat. You can set Integromat to post every day, every few days or even every few hours. The schedule settings in Integromat are flexible and will allow you to find a posting schedule that works for your business and for your specific Instagram Profile. Using a few simple Google Sheet formulas you can also assure that your Instagram post caption is withing the allowed 2200 characters length and you are keeping the number of hashtags below 30. Column names used in Google Sheets: Name Photo URL Google Drive Url Caption Length Hashtag Count Status Posted Date Instagram Id Instagram post caption length formula: = CONCAT(LEN(D2),"/2200") Count hashtags in Instagram caption formula: = CONCAT(LEN(D2)- LEN(SUBSTITUTE(D2,"#","")),"/30") Formula to create a download link from Google Drive share link: =CONCAT("https://drive.google.com/uc?export=do...",REGEXEXTRACT(C2,"d\/(.*)\/view")) Details of the video: 0:00 Instagram post pushed from inside Google Sheets! 0:30 Setting up Google Sheet spreadsheet with Instagram Content Plan 2:22 Google Sheet formula for counting number of hashtags in Instagram post caption 3:40 Setting up Integromat scenario to connect with Google Sheets 5:35 Setting up Integromat scenario to connect with Instagram 8:48 Creating downloadable links for photos in Google Drive 11:51 Create multiple posts inside Google Sheet 13:24 Setting up a posting schedule for Instagram Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at https://www.business-automated.com If you like our tutorials - buy us a coffee☕: https://www.buymeacoffee.com/business Follow us on Twitter🐦:   / bautomated   Read more on Medium 💆‍♂️:   / business-automated   #Instagram #Sheets #Automation