Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Please go to the video description, open the link, click on the "Apps Script" button, then send a request. After that, you will receive a script in your Gmail inbox.
Yes, you can access the script. If you want to access the script, please go to the video description, open the link, click on the "Access Script" button, then wait a few minutes to automatically receive the document in your email.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
function createWhatsAppHyperlink() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var lastRow = sheet.getLastRow(); var dataRange = sheet.getRange(2, 1, lastRow - 1, 4); // Assuming data starts from row 2 and you have 4 columns (A, B, C, D) var data = dataRange.getValues();
var whatsappLinks = [];
for (var i = 0; i < data.length; i++) { var phoneNumber = data[i][1]; // Assuming phone numbers are in column B (index 1) var message = data[i][0] + " - " + data[i][2] + " " + data[i][3]; // Merge data from columns A, C, and D var whatsappLink = "api.whatsapp.com/send?phone=" + phoneNumber + "&text=" + encodeURIComponent(message); var displayText = "click to send"; // The text you want to display as the hyperlink var hyperLinkFormula = '=HYPERLINK("' + whatsappLink + '","' + displayText + '")'; whatsappLinks.push([hyperLinkFormula]); }
var columnE = sheet.getRange(2, 5, whatsappLinks.length, 1); // Column E (index 5) to store the hyperlinks columnE.setFormulas(whatsappLinks);
Logger.log("WhatsApp hyperlinks with display text have been created successfully!"); }
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!" Outright Systems
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"" "
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"" "
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" 1
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
"Thank you for your wonderful comment! 😊 Your support keeps us going. If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
function createWhatsAppHyperlink() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var lastRow = sheet.getLastRow(); var dataRange = sheet.getRange(2, 1, lastRow - 1, 4); // Assuming data starts from row 2 and you have 4 columns (A, B, C, D) var data = dataRange.getValues();
var whatsappLinks = [];
for (var i = 0; i < data.length; i++) { var phoneNumber = data[i][1]; // Assuming phone numbers are in column B (index 1) var message = data[i][0] + " - " + data[i][2] + " " + data[i][3]; // Merge data from columns A, C, and D var whatsappLink = "api.whatsapp.com/send?phone=" + phoneNumber + "&text=" + encodeURIComponent(message); var displayText = "click to send"; // The text you want to display as the hyperlink var hyperLinkFormula = '=HYPERLINK("' + whatsappLink + '","' + displayText + '")'; whatsappLinks.push([hyperLinkFormula]); }
var columnE = sheet.getRange(2, 5, whatsappLinks.length, 1); // Column E (index 5) to store the hyperlinks columnE.setFormulas(whatsappLinks);
Logger.log("WhatsApp hyperlinks with display text have been created successfully!"); }
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"" "
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
" ""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"""" """
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services: store.outrightcrm.com. Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review. Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Great video. Is it possible to send the message automatically without the second click on whatsapp?
Soon we will be provided new script , using that user can send unlimited instant message , emails , screenshots and emails using appscripts on sheets.
Let me know when you're done with automatic messages
@@LifeAtOutRight please let me know as well :-)
@@LifeAtOutRight Hi, nice video....dou you have this script ? Pleeeease
Hi! great video! it's possible to send messages automatically in a loop function? thanks!
Sir please Tell me how can i send massage with image property and one click
Thank You so much.Easy to understand.
Thanks for watching.
What's use of google sheet if we send directly one by one?
you can Automate your process using google sheet
Hi, the video looks very useful, thanks. Could you please give me access to the script for sending WApp messages in a large scale
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Thank you for this awesome video. need access.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
how to send it to all in one click instead of sending everyone individually. any idea?
did you find a way?
Please my request for the script team.i will be very much thankful to all of you for this
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Hello, Im still waiting for approvement@@OutrightSystems
Helllo! What an amazing video. I just requested the script, could you pls allow access. Thanks
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Hello again, I checked my mailbox but haven't recieved any script yet🤔 @@OutrightSystems How do I get it?
Please check now, your request has been approved
It's very useful for me. Please allow access, thank you so much!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
can we send files also
Can i send a message to a bulk of number at once?
"Yes, you can send messages to multiple numbers with a single click. If you need this script, please send an email to promotion@outrightcrm.com .
Amazing video, loved watching it. i have shared a request with you on the mail pls provide that and i surely am adding this to my buisness sheets
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Great video Sir. Can I be given access to the script? Thank you so much
Please go to the video description, open the link, click on the "Apps Script" button, then send a request. After that, you will receive a script in your Gmail inbox.
how i can send the message for all the Numbers in one click
Please Watch Complete Video
Hi there, how can I request for the script please ?
Yes, you can access the script. If you want to access the script, please go to the video description, open the link, click on the "Access Script" button, then wait a few minutes to automatically receive the document in your email.
Hello. Can I please get the permission for the request I sent?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Will Whatapps ban me for doing this?
No
Please allow to access the link
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
How many messages can be sent per day?
you can send five hundred message per day
Thank you for your marvelous job done. It's an inspiring and helpful video! Kindly approve my request for access. Thank you.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Can you please give the permission ?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Please give me access to access the sheet!
Thanks for watching.
Approved!
Can I have access pleae to the script ?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Plss I need the script...😢
Pls allow access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Please send Link And Access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Not working on some error code
Can you tell me "What problems are facing this script?
Hey! Great video. Please allow my acess?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Thank you so much but I need access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
ciao! ma come si accede allo script?grazie!
Grazie per la visione.
Approvato!
script URL have need access
function createWhatsAppHyperlink() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lastRow = sheet.getLastRow();
var dataRange = sheet.getRange(2, 1, lastRow - 1, 4); // Assuming data starts from row 2 and you have 4 columns (A, B, C, D)
var data = dataRange.getValues();
var whatsappLinks = [];
for (var i = 0; i < data.length; i++) {
var phoneNumber = data[i][1]; // Assuming phone numbers are in column B (index 1)
var message = data[i][0] + " - " + data[i][2] + " " + data[i][3]; // Merge data from columns A, C, and D
var whatsappLink = "api.whatsapp.com/send?phone=" + phoneNumber + "&text=" + encodeURIComponent(message);
var displayText = "click to send"; // The text you want to display as the hyperlink
var hyperLinkFormula = '=HYPERLINK("' + whatsappLink + '","' + displayText + '")';
whatsappLinks.push([hyperLinkFormula]);
}
var columnE = sheet.getRange(2, 5, whatsappLinks.length, 1); // Column E (index 5) to store the hyperlinks
columnE.setFormulas(whatsappLinks);
Logger.log("WhatsApp hyperlinks with display text have been created successfully!");
}
Thanks for watching!
Approved
Kindly provide access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Outright Systems
Please allow access, thank you so much!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Kindly give me access. Thanks
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Please allow access to
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Thank you, please give access.
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Please allow access, thank you
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Access not given
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Hi, thanks for this awesome video. Can you please approve my request for the script?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
It's not sending.....
Your request has not been received. Please go to the video description and request the document.
Hai,please give me access to
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""
"
Allow access please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
thanks
@@OutrightSystems
why i can't see extensions in google sheet menu?
Hi,
Thanks for watching!
You are using google sheet?
Hiii great video, acess please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
give me access please
Hi. Please approved my access..
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Please allow access!
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""
"
Hi , i requested access. Please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Access Please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Pls provide access to my request ..
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Access please🔗
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
1
Link needs access
Thanks for watching.
Approved!
Thank you. Please grant access.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Accessibility please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
thank u
"Thank you for your wonderful comment! 😊 Your support keeps us going. If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
access pls sir/maam.
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
please give access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Erro: Erro de análise de fórmula.
Hi,
Thanks for watching.
Please share the screenshot what issue you are facing.
Email: sharma.mohit@outrightcrm.com
Share me copy of that sheet
function createWhatsAppHyperlink() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lastRow = sheet.getLastRow();
var dataRange = sheet.getRange(2, 1, lastRow - 1, 4); // Assuming data starts from row 2 and you have 4 columns (A, B, C, D)
var data = dataRange.getValues();
var whatsappLinks = [];
for (var i = 0; i < data.length; i++) {
var phoneNumber = data[i][1]; // Assuming phone numbers are in column B (index 1)
var message = data[i][0] + " - " + data[i][2] + " " + data[i][3]; // Merge data from columns A, C, and D
var whatsappLink = "api.whatsapp.com/send?phone=" + phoneNumber + "&text=" + encodeURIComponent(message);
var displayText = "click to send"; // The text you want to display as the hyperlink
var hyperLinkFormula = '=HYPERLINK("' + whatsappLink + '","' + displayText + '")';
whatsappLinks.push([hyperLinkFormula]);
}
var columnE = sheet.getRange(2, 5, whatsappLinks.length, 1); // Column E (index 5) to store the hyperlinks
columnE.setFormulas(whatsappLinks);
Logger.log("WhatsApp hyperlinks with display text have been created successfully!");
}
Thanks for watching.
Script Code: docs.google.com/document/d/1brtaZKtumT5TMfliit1H5P3uIVdLBYJRtGzPKCoewHs/edit?usp=sharing
How I can set Api
Mujhe bot banna h api maytapi ki h plz help me
Kindly approve my request for access!
"Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""
"
please give accesss
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
allow acces please, thanks
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
please grant me access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
please approved, sir. thank you
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Kindly approve my request
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
please approve
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Give me accesssssssss
Thanks for watching.
Approved!
Hi, please approve
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Please accept the request
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
hi, aproove me!
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Hello. Can I please get the permission for the request I sent?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Thank you for your marvelous job done. It's an inspiring and helpful video! Kindly approve my request for access. Thank you.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hi, kindly provide access@@OutrightSystems
Please allow access
Thanks for watching.
Approved!
Kindly provide access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
access not given
Thanks for watching!
Your access approved!
Allow access please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
access please
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
please give me the access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Give me access please
Thanks for watching.
Approved!
Please give access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Kindly provide access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Allow access please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Please allow access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
please allow access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
access please
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Please allow access
need access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
need access
Thanks for watching.
Approved!
access please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
need access
Thanks for watching.
Approved!
please give me the access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
give me access please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
give me access please
Thanks for watching.
Approved!
give me access please
Thanks for watching.
Approved!
give me access
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
give me access
Thanks for watching.
Approved!