Author: admin
In a previous tutorial, you learned how to send WhatsApp messages from Google Sheets using the official WhatsApp API. The first 1,000 messages per month for each WhatsApp Business Account are free and then you pay per use based on the country of the message sender and the message recipient. WhatsApp API Pricing For instance, if you are sending a WhatsApp message from the US phone number to a WhatsApp user in France, the cost would be 14¢ per message. However, if you send messages from WhatsApp number in India to another number in India, the cost would be around…
This step-by-step tutorial describes how you can connect to the Gmail SMTP server for sending emails from a Node.js web application that could be deployed on Google Cloud Functions, AWS Lambda, Cloud Run or running on your local machine. And unlike most other Node SMTP tutorials that use the username and password combination, this approach uses OAuth and doesn’t require you to turn on less secured apps access in your Google account. Create Gmail OAuth Credentials Create a new Google Cloud Project and enable the Gmail API as described in a previous tutorial. In the APIs & Services section, click…
Set reminders with @RemindMe_OfThis An open-source Twitter bot that lets you easily set reminders for public tweets. Mention @RemindMe_OfThis in the reply of any tweet and specify the time in natural English when you would like to reminded of that tweet. You could say things like in 2 days or in 12 hours or next week or even in 5 years. Check out the source on Github. Save Twitter Threads with @ThreadReaderApp The gurus on Twitter have figured out that threads are the best way to extend the reach of their tweets and @ThreadReaderApp makes is really easy for you…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
We have created a simple quiz in Google Forms that has 3 questions and each correct answer gives you 10 points. The maximum score that can be attained in the quiz in thus 30 points. When someone takes the quiz and submits the form, the responses are recorded in a Google Sheet that is set as the response destination for your Google Form. There’s something interesting here as well. If the associated form is a quiz, Google Sheets will automatically add an extra column in the response sheet titled “Score” and this column will be populated with the total marks…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
Whether it is a wedding party or a business conference, those tent-shaped place cards are ideal for helping your guests find their seats at the event. This tutorial explains how you can create personalized place cards with the names of your guests and the table number to which they have been assigned. We’ll use Google Sheets to create the party seating plan, Google Slides to design the place card template and Document Studio to generate those place cards as PDF files in Google Drive. Let’s get started. Create Guest Seating Plan Create a new spreadsheet inside Google Sheets (sheet.new), enter…
A school provides email accounts for students that are enrolled in high school. The school has published a Google Form and any student can put their name in the form to request access to an email address. Parent’s consent is required though. When a child submits the request, an email confirmation is sent to the parent of the child for them to provide consent before the student’s email address can be created. Lookup Parent’s Data in Google Sheets The key here is that an email should be sent to the parent of the student. This data itself is not available…
Would you like to know how much traffic (or page views) other websites in your niche are getting for competitive analysis? While it will be difficult for any third-party to accurately measure the traffic of a site, there are a bunch of traffic estimation services that can give you a better understanding of the popularity of a website. Here’s a list: 1. Similar Web – It started as a tool for finding similar sites but now offers a range of data including traffic analysis in a clean interface. You get to know the site’s traffic over time, the countries that…
The Document Studio add-on helps you automatically send text messages when a new Google Form is submitted or when new rows are added to Google Sheets. You can thus build workflows that send text reminders when the invoices are due. Or you can get notified instantly when people fill out your Google Forms. The SMS Workflow The text messages in Document Studio are sent through Twilio but the app can be integrated with any SMS service as long as the service offers an API for sending text messages programmatically. You may use TextMagic, SimplyTexting, Vonage, ClickSend, RingCentral, or any SMS…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
An order form, created in Google Forms, requires customers to provide their full name, the item quantity and whether home delivery is required. The final bill amount is calculated with a simple formula in Google Sheets. // Item cost is $99 per unit. Delivery cost is $19. =IF(ISNUMBER(C2), SUM(C2*99, IF(D2=”Yes”, 19, 0)), ) The Google Sheet owner has entered the formula across all rows in the Total Amount column so that the value is automatically calculated when a new form response is submitted. The problem is that the formulas in Google Sheets are automatically deleted when new responses come in.…