- 115
- 127 841
Data In Nut Shell
India
เข้าร่วมเมื่อ 15 ก.พ. 2022
My videos will make you more 🚀 productive at your work !! Are your Ready ?
Visit My Website for :
Automated Solutions - datainnutshell.com/productivity-tools-for-teams/
For Technical Blogs - datainnutshell.com/blog/
#gmail #googlecalendar #googlesheets #excel #exceltips #exceltutorial #exceltricks #excelformula #googlesheetstutorial #googleslides #googledocstutorial #iphonetricks #python #learnpython #automation
Visit My Website for :
Automated Solutions - datainnutshell.com/productivity-tools-for-teams/
For Technical Blogs - datainnutshell.com/blog/
#gmail #googlecalendar #googlesheets #excel #exceltips #exceltutorial #exceltricks #excelformula #googlesheetstutorial #googleslides #googledocstutorial #iphonetricks #python #learnpython #automation
Google Sheets Translate Formula
Translate content to any language using Google Sheets and Google Translate
#googletranslate #googlesheets #languagetranslation #googlesheetstips
#googletranslate #googlesheets #languagetranslation #googlesheetstips
มุมมอง: 12
วีดีโอ
Expense Tracker Using Google Sheets
มุมมอง 6914 วันที่ผ่านมา
How to use Google Sheets for budgeting | 100% Free, Visit : datainnutshell.com/free-monthly-budget-tracker-by-datainnutshell/ #budgeting #expensetracking #expensetracker #expensemanagement
How to highlight duplicate values in Google Sheets
มุมมอง 6428 วันที่ผ่านมา
Using conditional formatting you can highlight duplicate values in Google Sheets #googlesheets #googlesheetstips #googlesheetstutorial
How to Sync Google Contacts with Iphone
มุมมอง 421หลายเดือนก่อน
This video explains how to sync your google contacts of various gmail account with your iphone contacts list Searching for AI tools summary ? - datainnutshell.com/best-ai-tools-in-2025-categorized-by-features-like/ #gmail #iphone #googlecontacts #contacts
How to use Google Calendar effectively | Gmail
มุมมอง 38หลายเดือนก่อน
Super-Fast to the point video - on How to send calendar invite in Gmail #gmail #calendar #googlecalendar #india
How to Delete Sent Emails from Receiver's Inbox in Gmail
มุมมอง 1.7K2 หลายเดือนก่อน
This video explains the option with which you can delete any email from receiver's inbox in Gmail #gmail #email #emailmanagement #email
How to create signature with logo | Gmail
มุมมอง 912 หลายเดือนก่อน
Learn how to add email signature and logo in Gmail #gmail #gmailtips #gmailtipsandtricks
How to Change Email Name on Gmail
มุมมอง 432 หลายเดือนก่อน
Change Gmail display name in 1 minute. #gmail #gmailapp #tipsandtricks
How to retrieve archived emails in Gmail
มุมมอง 743 หลายเดือนก่อน
This video explains how to - - Filter our archived emails in gmail - Move back Archived Emails to Inbox For more products visit our website - datainnutshell.com/ #gmail #gmailsearch #unarchive #email #emailmanagement
How To Do a Mail Merge in Gmail | Google App Script | Google Sheets
มุมมอง 1673 หลายเดือนก่อน
Video explains how to do a mail merge in gmail! #googleappsscript #googlesheets #mailmerge #datainnutshell
How to Send Bulk Email from Gmail | Google App Script
มุมมอง 1883 หลายเดือนก่อน
Send beautiful HTML emails to your customers. No need of Mailchimp buy.stripe.com/dR63elf4O6MU3K000h #googlesheets #googleappsscript #bulkemailsender #bulkemail #mailchimp
Mass Unsubscribe Gmail | Google App Script
มุมมอง 1033 หลายเดือนก่อน
This tool helps you to unsubscribe mass emails in Gmail account. #gmail #googleappscript #email
Export Gmail Emails to CSV | Gmail | Google App Script | Download Emails
มุมมอง 1193 หลายเดือนก่อน
Try !! Gmail Automation - One Stop Solution This Tool can Cleanup , Auto Labels Emails, Extract information from Email body and all in bulk. #productivity #gmail #googleapps #googleappsscript #googlesheets
How to Extract Data from Email Body and Paste into Google Sheets | Gmail | Google App Script
มุมมอง 4084 หลายเดือนก่อน
How to Extract Data from Email Body and Paste into Google Sheets | Gmail | Google App Script
How to Automatically Label Emails in Gmail | Google Sheets | Google App Script | Gmail
มุมมอง 754 หลายเดือนก่อน
How to Automatically Label Emails in Gmail | Google Sheets | Google App Script | Gmail
How to Automatically Label Emails in Gmail | Google Sheets | Google App Script | Gmail
มุมมอง 1154 หลายเดือนก่อน
How to Automatically Label Emails in Gmail | Google Sheets | Google App Script | Gmail
How to delete multiple emails on Gmail app | Google Sheets | Google App Script
มุมมอง 1074 หลายเดือนก่อน
How to delete multiple emails on Gmail app | Google Sheets | Google App Script
How to Import ICS file format to Google Calendar
มุมมอง 6045 หลายเดือนก่อน
How to Import ICS file format to Google Calendar
How to highlight duplicates in google sheets
มุมมอง 515 หลายเดือนก่อน
How to highlight duplicates in google sheets
Convert Image to PDF | Combine all Images to PDF
มุมมอง 485 หลายเดือนก่อน
Convert Image to PDF | Combine all Images to PDF
Natural Language Processing | Sentiment Analysis Tool #2024 | nlp căn bản
มุมมอง 295 หลายเดือนก่อน
Natural Language Processing | Sentiment Analysis Tool #2024 | nlp căn bản
How to use SumIf Function in Excel and Google Sheets
มุมมอง 456 หลายเดือนก่อน
How to use SumIf Function in Excel and Google Sheets
How to take text from image | Google Colab | Python
มุมมอง 616 หลายเดือนก่อน
How to take text from image | Google Colab | Python
How to Convert PDF to Excel | Using Google Colab #2024
มุมมอง 3416 หลายเดือนก่อน
How to Convert PDF to Excel | Using Google Colab #2024
Auto Create Google Forms using Google Sheets | How to make Google form | Google App Script
มุมมอง 3417 หลายเดือนก่อน
Auto Create Google Forms using Google Sheets | How to make Google form | Google App Script
How To Auto Populate Goolgle Form Dropdown Values by Goolge Sheets | Google App Script
มุมมอง 2407 หลายเดือนก่อน
How To Auto Populate Goolgle Form Dropdown Values by Goolge Sheets | Google App Script
Bulk Sender | Using Google App Script | #emailmarketing
มุมมอง 1497 หลายเดือนก่อน
Bulk Sender | Using Google App Script | #emailmarketing
Automate Google Slides | Google App Script
มุมมอง 3437 หลายเดือนก่อน
Automate Google Slides | Google App Script
This is very helpful, but how would It work with multiple answer questions (the user is able to choose more than one option)? Thank u 😁
@@JulioSilva-tr7nd Thanks, method is same just duplicate the entry. and option value
hi sir i want to send student marks means progress report with school logo and student photo how to do can u explain please
@@mravi330 you have to uploads all students photos with their names in the google drive and i believe marks wll be in your google sheets, then you can code it accordingly
thanks for the tutorial!!🤎
@@NextGenGames0 Your welcome
CAN YOU PROVIDE CODE PLZ
It has been added in our Gmail one stop solution tool - datainnutshell.com/how-to-automate-your-gmail/ You can get the tool and explanation under : Mail merge in Gmail Note : It is a paid tool
Thank you so much for this video it's very helpful
Glad it was helpful!
Hi, how to get the sheets?
@@carmelannemuassab2422 you can visit my website and buy it from there. Tool Name - Gmail one stop solution datainnutshell.com/how-to-automate-your-gmail/
Any chance the Google Sheets are available?
It is not available but now Google has updated it Google Contacts software and you can upload vcf or download in excel. It is much better, you can give it a try.
i love you, you're a life-saver
Thanks 🙏
One of the best tech advice
@@amandeepsinghid Thanks 🙏
Do you have a workaround for when the maximum characters in the pre-filled url has been exceeded? for example I have a pre-filled url which I am creating with apps script but the users are puting a lot of data now the url end up becoming too long. when I click on the link I get erro 400.
hmm its very specific, have you tried using short question type ? , it restrict users to some characters.
@@DataInNutShell thank you for the prompt reply, Yes I di that, I applied data validation on the google for to limit the character, However I am getting resistance from the users. I wanted to do the character limit as the last resort. However I cannot seem to find another work around solution.
I have a slide show of 30 speakers. On each slide there will be a box that says "next speaker" and show the title of the NEXT SPEAKER. I would love to be able to randomize these slides weekly and have the name of the NEXT SPEAKER update based on the title of the slide after that slide. Is this possible?
Would require a template before confirming
Really helpful 😊
@@ExcelDose Thanks 🙏
Please turn off the background noise. No one can understand you with that noise.
Sure, You can watch this and it is without noise : th-cam.com/video/NmbGSQ8pKKY/w-d-xo.html
Very helpful, thanks!
Glad it was helpful!
Can we update record in same row ?
@@nikhilkapadia741 we can do that but for that we need to update the code accordingly
what if the form is not mine. and it has time to open. Will this method work?
You have to ask for a pre-filled form from the owner
This great!
Thanks!
Apologies for late reply, Yes it is possible but instead of concatenate you have to manually combine data liek (A2&B2). Let me know if still you need help!
Great video 🎉
@@ExcelDose Thanks
thanks its good
Thanks
tem.evaluate is not a function i am getting error
Give me your sheet at pbtchinaa@gmailcom will check it, it is working for me.
What if the form has many pages
In that case you have to use app script
@@DataInNutShell can you please provide more informations
Can provide me tutorial link or anything can help I appreciate that
@@donkhalil6467 you can send me a sample google form at datainnutshellsolutions@gmail.com and in few weeks time wll try to create a video on it.
May I have the googlesheet please? 😀
I would love to provide it, but i mistakenly gave edit to someone and he deleted main copy 🙏, It is in my work queue soon I wll update the google sheet it in comments section. 😅
@@DataInNutShell Aaww understood 🙏
May I have the google sheet pls?
Google has updated it Google Contacts software and you can upload vcf or download in excel. It is much better, you can give it a try.
I think video should contain more info...from scratch
@@haanjji true i use to upload longer videos but people usually watch shorter video more so changed my format. If anyone need the product then i provide one on one sessions to explain it in detail.
@@DataInNutShell so should you charge it?
I believe yes. Adding all types of automation scenarios that a normal gmail user could face, charging a one time fee instead of subscription based model is fine. With this I personally get it setup who ever buys it so for the time and efforts I put in this is minimum i charge. If you are looking for a free email sender this can help you Please read google policies before using : How to Send Emails from Google Sheets | Email HTML Table Data From Google Sheets | Google App Script th-cam.com/video/dWwlhDeAzB4/w-d-xo.html and How To Trigger Emails From Check Box Ticks | Google App Script | Send Bulk emails th-cam.com/video/27fYgYwfK1E/w-d-xo.html
@@DataInNutShell can i try this with new email and will these emails land in spam folder?
@@hariskhh yes there is possibility, if people mark you as spam or you have spelling mistakes or grammer mistakes then also it can go in spam but if u send it systematiclly then you can sail through.
I am interested in your product. Also worrying that if I couldnt make it work after buing the code.
@@lovetaiwan708 we can connect from gmail, Don't worry I will help you over call to make you understand how it works and will help you to install it as well. datainnutshellsolutions@gmail.com Out Products : datainnutshell.com/productivity-tools-for-teams/
mine comes up with an error saying TypeError: Cannot read properties of null (reading 'getRange') can you fix this
Share your sheet/doc at pbtchinaa@gmailcom will check it, it is working for me.
Sir, Pls can you share this script it will helpfully for us
You can get access to entire Gmail automation tool from here : datainnutshell.com/how-to-automate-your-gmail/
Looks nicely done - congratulations. It this a free or paid templete or a free or paid add-on? How to get and how much thanks
Thanks, Gmail Automation One stop solution is a paid tool with one time fee. All current and upcoming features will be available for life time. buy.stripe.com/dR63elf4O6MU3K000h
This has been useful, but the only part that is not autofilling is the date. Is there something different that needs to be done to have this function work?
@@VondaDavis-r1d it should fill it as well, can u gve me the link on my email wll check pbtchinaa@gmail.com
Hi .I don't have all the emails with labels. Please advise in that case what should be the process?
you can watch this : How to Automatically Label Emails in Gmail | Google Sheets | Google App Script | Gmail th-cam.com/video/o6zbWav2tWU/w-d-xo.html
@@DataInNutShell thanks.
Is it possible to extract only one data type from the email
in most of the cases yes
@@DataInNutShell Can you help me with a script to extract only one data type from the email
email sample n content you need @pbtchinaa@gmail.com
works 100% well, no bullshits and nonsense, hatsoffs🤝
Thanks!
great work
Thankyou
Easy explanation. But if I want to add 3 question in the same form then how to do it ? Please explain
Then you have to use google script code for it.
Thank you so much❤
You're welcome 😊
Hello sir need little bit help
Hi, pls send your query at pbtchinaa@gmail.com
@@DataInNutShell mail send sir. Please check. I send whole code with my problem. Please check it out sir
How can I get the app script ?
It has been added in our Gmail one stop solution tool - datainnutshell.com/how-to-automate-your-gmail/ You can get the tool and explanation under : Mail merge in Gmail Note : It is a paid tool
thank you! I know javascript and just learning GOOGLE APPS SCRIPT SPECIFIC STUFF is such a horrible task and this is so hard to learn without gems like this. Thank you!
Thanks a lot 👍
Hello please I need a code to pull out email addresses, recipient name, and date of last contact
Hi, please email your requirement at pbtchinaa@gmail.com
Thank you for being very patient sir. One of the best tools i ever purchased. Will sure to purchase from you in future. Great buy guys. Do look up for great tools from Data in nutshell..
Happy to hear the feedback :)
Go to field and play cricket with kids; what a meaningless video ever I seen in internet😄
Thanks for the feedback, let me know what to improve will definitely work on that. ✌️
@@DataInNutShell I have a great expectation when I saw you caption but content is not satisfactory even not needed by anyone in today's automation world.
@@debu4118 next video is auto update google forms question values from app script, i hope u you wll like it. Also there are people who still struggle with basic stuff , I create videos based on trends so that means people are searching it 😅
You can contact me at pbtchinaa@gmail.com
@@DataInNutShell For What?
it shows gmaill app not defined
Share your sheet/doc at pbtchinaa@gmailcom will check it, it is working for me.
Hi, Thank you for making such an useful tutorial. I followed the steps in the video and succeeded to attach an image in the email. However, I encountered error while trying to attach multiple images in an email. I tried writing inlineImages:{image1, image2} and it failed. Could you kindly explain how to attach several images in an email? I'll be grateful with an reply. Thank you~
Hi Janet, thanks for your feedback, I wll create and wll upload video related to it very soon, thnaks
Thank you for replying! I’m looking forward to the video. Have a great day❤
Hi Janet, are you only looking for inline images or you want to attach images as an attachment ? Please checout this tool if it suffice your requirement. datainnutshell.com/2024/03/15/streamline-email-outreach-with-our-web-app/ In this you just have to add image ids as comma separated list.
How to export all sent items in Gmail to a spread sheet or excel with email sent date, To, CC, Email summary
You can get access to entire Gmail automation tool from here : datainnutshell.com/how-to-automate-your-gmail/ It contains various custom features which can help in your query
Awsm thanks a lot
Thanks!
yes
I am using index-match to determine if a user is a member from another sheet. If found, I will extract other information. The formular below gets the email address. I also need to get other information so this formular is repeated for other columns the formular works except when I wrap it inside the arrayformula. I tried putting the range such as B2:B etc but it either does not work for other rows, or it returns the same value everytime. Can you tell what is wrong? =if(B2<>"",ifna(INDEX(All_Members!E:E,MATCH(B2,All_Members!G:G,False)),""),"") sp B2 contains the name, All_Members!G:G contains all member names, All_Members E:E contains data I am interested in, in this case, email address
Apologies for late reply, I believe your query might have been resolved if not then please email us in case you need faster resolution : @ pbtchinaa@gmail.com
thanks, I've looking for the combination of concatenate with array formula. Possible others combined with array formulas later
Amazing, thanks for your video. I'm trying to fill this boxes from a Google Sheets file
Glad it was helpful!
Gajab.
Thanks