![]() ![]() On the next screen, click on "Create a service account". Click "Create credentials" > "Help me choose".Īdd credentials for "Google Sheets API", "Other UI (e.g. Next, go to "APIs & Services" > "Credentials". Select "Google Sheets API" card, then "ENABLE". Next, go to "APIs & Services" > "Library" and search for "sheets". Accessing the spreadsheet via a Google service accountĪ service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs.Ĭreate a "New Project" by clicking "Select a project" at the top of the page. This file is something we need to get from the Google Cloud Platform console. This error occurs because we're missing the privatekey.json file. This ID will be used in our code and it is the value between the "/d/" and the "/edit" in the URL of your spreadsheet. Here is a screen capture of the "Appointments" spreadsheet, "Sheet1" worksheet:Īnother thing to do here is to find the spreadsheet ID. When entering the phone number, to be able to enter the + you need to prepend it with an apostrophe (or single quote) like this: '+17775553333. We'll use the first row as columns' header and name the first 4 columns as "appointment_date", "appointment_time", "client_name" and "phone_number".įill in the first 3 rows with data for appointment date and time, client name and client's WhatsApp phone number (for testing purposes one or all of the numbers can be your number). The new spreadsheet comes with one default worksheet with the name of "Sheet1" (this name matters, we will use it later to refer to this specific worksheet). You can name your spreadsheet whatever you want, because we will access the spreadsheet by its ID not by its name, but let’s rename it as "Appointments". Once you’re logged into your Google account, create a new "Google Sheets" blank spreadsheet by clicking the "+ New" button in the upper left. Use a web browser and go to (log in if needed). I use the free Visual Studio Code with the integrated terminal Node.js & npm installed (you can install it from ).A Google Cloud Platform free tier account.A Google Sheets account (comes free with a Google account).Let's start with a name and call it "A Message Sender". We'll take an iterative approach building this application. It uses a Google Sheets spreadsheet as the data source for contacts and Twilio's API for WhatsApp to send the messages. ![]() In this post, you will learn how to create a Node.js application which can be used to send WhatsApp messages to multiple recipients. You can send simple text messages and you can also send attachments containing pictures, audio clips or video recordings. It allows you to send messages to another person who is also using WhatsApp. WhatsApp is a popular app for smartphones that offers a replacement to traditional text messaging systems. The structure and simplicity of keeping data in rows and columns brings many benefits. With Google Sheets (online spreadsheet app from Google) you can easily collaborate in real-time with coworkers, clients, or others. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |