Skip to content

Commit 56c9457

Browse files
AchoArnoldAchoArnold
committed
Add 2 blog posts about CSV and Excel
1 parent af07e67 commit 56c9457

8 files changed

Lines changed: 490 additions & 33 deletions

‎web/components/BlogAuthorBio.vue‎

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,36 @@
1+
<template>
2+
<div class="d-flex mb-6 mt-8">
3+
<v-avatar class="mb-n2">
4+
<v-img :src="require('@/assets/img/arnold.png')"></v-img>
5+
</v-avatar>
6+
<div class="ml-2">
7+
<p class="subtitle-1 mb-n1">Acho Arnold</p>
8+
<a
9+
class="mb-n4 text-decoration-none text--primary"
10+
href="https://twitter.com/acho_arnold"
11+
>
12+
<v-icon color="#1DA1F2">{{ mdiTwitter }}</v-icon>
13+
</a>
14+
<a
15+
class="ml-2 text-decoration-none text--primary"
16+
href="https://github.com/AchoArnold"
17+
>
18+
<v-icon color="#FFFFFF">{{ mdiGithub }}</v-icon>
19+
</a>
20+
</div>
21+
</div>
22+
</template>
23+
24+
<script lang="ts">
25+
import { mdiTwitter, mdiGithub } from '@mdi/js'
26+
27+
export default {
28+
name: 'BlogAuthorBio',
29+
data() {
30+
return {
31+
mdiTwitter,
32+
mdiGithub,
33+
}
34+
},
35+
}
36+
</script>

‎web/pages/blog/forward-incoming-sms-from-phone-to-webhook.vue‎

Lines changed: 1 addition & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -126,21 +126,7 @@
126126
>
127127
</p>
128128
<p>Until the next time✌️</p>
129-
<div class="d-flex mb-6 mt-8">
130-
<v-avatar class="mb-n2">
131-
<v-img :src="authorImage"></v-img>
132-
</v-avatar>
133-
<div class="ml-2">
134-
<p class="subtitle-1 mb-n1">{{ authorName }}</p>
135-
<a
136-
class="mb-n4 text-decoration-none text--primary"
137-
href="https://twitter.com/acho_arnold"
138-
>
139-
{{ authorTwitter }}
140-
<v-icon color="#1DA1F2" small>{{ mdiTwitter }}</v-icon>
141-
</a>
142-
</div>
143-
</div>
129+
<blog-author-bio></blog-author-bio>
144130
<v-divider class="mx-16"></v-divider>
145131
<div class="text-center mt-8 mb-4">
146132
<back-button></back-button>

‎web/pages/blog/how-to-send-sms-messages-from-excel.vue‎

Lines changed: 208 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,208 @@
1+
<template>
2+
<v-container class="pt-8">
3+
<v-row class="mt-16">
4+
<v-col cols="12" md="9">
5+
<h1
6+
class="mt-1"
7+
:class="{
8+
'text-h2': $vuetify.breakpoint.mdAndUp,
9+
'text-h3': !$vuetify.breakpoint.mdAndUp,
10+
}"
11+
>
12+
How to send SMS messages to multiple phone numbers from Excel
13+
</h1>
14+
<p class="subtitle-2 mt-2">
15+
<span class="text-uppercase blue--text">{{ postDate }}</span>
16+
• <span class="text-uppercase">{{ readTime }}</span>
17+
</p>
18+
<p class="text--secondary subtitle-1 mt-2">
19+
Send personalized SMS messages to multiple phone numbers for less than
20+
<b>$0.002 </b> per SMS message. You can also configure every SMS
21+
message in your Excel spreadsheet so they are unique for each
22+
recipient phone number.
23+
</p>
24+
<h3 class="text-h4 mt-8 mb-2">Prerequisites</h3>
25+
<ul>
26+
<li>Basic understanding of Microsoft Excel or Google Sheets.</li>
27+
<li>An Android phone.</li>
28+
</ul>
29+
<h3 class="text-h4 mt-8 mb-2">Step 1: Get your API Key</h3>
30+
<p>
31+
Create an account on
32+
<nuxt-link class="text-decoration-none" to="/">httpsms.com</nuxt-link>
33+
and copy your API key from the settings page
34+
<nuxt-link class="text-decoration-none" to="/settings"
35+
>https://httpsms.com/settings</nuxt-link
36+
>
37+
</p>
38+
<vue-glow
39+
color="#329ef4"
40+
mode="hex"
41+
elevation="14"
42+
:intensity="1.07"
43+
intense
44+
>
45+
<v-img
46+
style="border-radius: 4px"
47+
alt="httpsms.com settings page"
48+
:src="
49+
require('@/static/img/blog/forward-incoming-sms-from-phone-to-webhook/settings.png')
50+
"
51+
></v-img>
52+
</vue-glow>
53+
<h3 class="text-h4 mb-4 mt-16">
54+
Step 2: Install the httpSMS android app
55+
</h3>
56+
<p>
57+
<a
58+
target="_blank"
59+
class="text-decoration-none"
60+
href="https://github.com/NdoleStudio/httpsms/releases/latest/download/HttpSms.apk"
61+
>⬇️ Download and install</a
62+
>
63+
the httpSMS android app on your phone and sign in using your API KEY
64+
which you copied above. This app listens for SMS messages received on
65+
your android phone.
66+
</p>
67+
<v-alert type="info" outlined>
68+
Make sure to enter your phone number in the international format e.g
69+
+18005550199 when authenticating with the httpSMS Android app.
70+
</v-alert>
71+
<v-img
72+
style="border-radius: 4px"
73+
alt="httpsms android app"
74+
height="800"
75+
contain
76+
:src="
77+
require('@/static/img/blog/forward-incoming-sms-from-phone-to-webhook/android-app.png')
78+
"
79+
></v-img>
80+
<h3 class="text-h4 mt-12">Step 3: Edit your Excel file</h3>
81+
<p>
82+
Download the
83+
<a
84+
class="text-decoration-none"
85+
href="/templates/httpsms-bulk.xlsx"
86+
download
87+
>httpSMS Excel file template</a
88+
>
89+
and edit it with your favorite spreadsheet software e.g Excel, Google
90+
Sheets, Open Office etc. Fill in the phone number which you registered
91+
in httpSMS in the <code>FromPhoneNumber</code> column and fill in the
92+
number of the recipient of the SMS in the
93+
<code>ToPhoneNumber</code> column. Also add the SMS which you want to
94+
send in the message in the <code>Content</code> column.
95+
</p>
96+
<v-alert type="info" outlined class="mt-2 mb-4">
97+
Make sure to use the correct <code>FromPhoneNumber</code> from step 2
98+
above in your Excel file
99+
</v-alert>
100+
<v-img
101+
style="border-radius: 4px"
102+
alt="httpsms android app"
103+
height="800"
104+
contain
105+
:src="
106+
require('@/static/img/blog/send-bulk-sms-from-csv-file-with-no-code/httpms-spreedsheet.png')
107+
"
108+
></v-img>
109+
<h3 class="text-h4 mt-12">Step 3: Send the SMS Messages</h3>
110+
<p>
111+
Visit the
112+
<router-link class="text-decoration-none" to="/bulk-messages"
113+
><v-icon color="primary" x-small>{{
114+
mdiCommentTextMultipleOutline
115+
}}</v-icon>
116+
Bulk Messages</router-link
117+
>
118+
page on httpSMS and upload your Excel file and send the your SMS
119+
messages.
120+
</p>
121+
<vue-glow
122+
color="#329ef4"
123+
mode="hex"
124+
elevation="14"
125+
:intensity="1.07"
126+
intense
127+
>
128+
<v-img
129+
style="border-radius: 4px"
130+
alt="httpsms android app"
131+
height="800"
132+
contain
133+
:src="
134+
require('@/static/img/blog/send-bulk-sms-from-csv-file-with-no-code/bulk-csv-upload.png')
135+
"
136+
></v-img>
137+
</vue-glow>
138+
<p class="mt-12">
139+
Don't hesitate to
140+
<a class="text-decoration-none" href="mailto:arnold@httpsms.com"
141+
>contact us</a
142+
>
143+
if you face any issues sending bulk SMS messages from your Excel files
144+
by following this tutorial.
145+
</p>
146+
<p>Until the next time✌️</p>
147+
<blog-author-bio></blog-author-bio>
148+
<v-divider class="mx-16"></v-divider>
149+
<div class="text-center mt-8 mb-4">
150+
<back-button></back-button>
151+
</div>
152+
</v-col>
153+
<v-col v-if="$vuetify.breakpoint.mdAndUp" md="3">
154+
<blog-info></blog-info>
155+
</v-col>
156+
</v-row>
157+
</v-container>
158+
</template>
159+
160+
<script lang="ts">
161+
import { mdiTwitter, mdiCommentTextMultipleOutline } from '@mdi/js'
162+
export default {
163+
name: 'SendBulkSmsToMultiplePhoneNumbersFromExcel',
164+
layout: 'website',
165+
data() {
166+
return {
167+
mdiTwitter,
168+
mdiCommentTextMultipleOutline,
169+
authorImage: require('@/assets/img/arnold.png'),
170+
authorName: 'Acho Arnold',
171+
postDate: 'October 29, 2023',
172+
readTime: '5 min read',
173+
authorTwitter: 'acho_arnold',
174+
}
175+
},
176+
head() {
177+
return {
178+
title:
179+
'How to send SMS messages to multiple phone numbers from Excel - httpSMS',
180+
meta: [
181+
{
182+
hid: 'og:title',
183+
property: 'og:title',
184+
content:
185+
'How to send SMS messages to multiple phone numbers from Excel',
186+
},
187+
{
188+
hid: 'og:description',
189+
property: 'og:description',
190+
content:
191+
'Configure your Android phone as an SMS gateway to automate sending text messages with the Python programing language.',
192+
},
193+
{
194+
hid: 'twitter:card',
195+
name: 'twitter:card',
196+
content: 'summary_large_image',
197+
},
198+
{
199+
hid: 'og:url',
200+
property: 'og:url',
201+
content:
202+
'https://httpsms.com/blog/how-to-send-sms-messages-from-excel',
203+
},
204+
],
205+
}
206+
},
207+
}
208+
</script>

‎web/pages/blog/index.vue‎

Lines changed: 27 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -33,10 +33,10 @@
3333
<div class="ml-2">
3434
<p class="subtitle-1">{{ post.authorName }}</p>
3535
<p class="mt-n5 mb-n4">
36-
{{ post.authorTwitter }}
37-
<v-icon color="#1DA1F2" small>{{
36+
<v-icon small color="#1DA1F2">{{
3837
mdiTwitter
3938
}}</v-icon>
39+
<v-icon small color="#ffffff">{{ mdiGithub }}</v-icon>
4040
</p>
4141
</div>
4242
</div>
@@ -55,15 +55,39 @@
5555
</template>
5656

5757
<script lang="ts">
58-
import { mdiTwitter } from '@mdi/js'
58+
import { mdiGithub, mdiTwitter } from '@mdi/js'
5959
6060
export default {
6161
name: 'BlogIndex',
6262
layout: 'website',
6363
data() {
6464
return {
6565
mdiTwitter,
66+
mdiGithub,
6667
blogPosts: [
68+
{
69+
route: '/blog/how-to-send-sms-messages-from-excel',
70+
title:
71+
'How to send SMS messages to multiple phone numbers from Excel',
72+
date: 'October 29, 2023',
73+
readTime: '5 min read',
74+
authorImage: require('@/assets/img/arnold.png'),
75+
description:
76+
'Send multiple SMS messages to your customers from a an Excel file using your Android phone as the SMS gateway.',
77+
authorName: 'Acho Arnold',
78+
authorTwitter: 'acho_arnold',
79+
},
80+
{
81+
route: '/blog/send-bulk-sms-from-csv-file-with-no-code',
82+
title: 'Send bulk SMS messages from a CSV file with no code',
83+
date: 'October 29, 2023',
84+
readTime: '7 min read',
85+
authorImage: require('@/assets/img/arnold.png'),
86+
description:
87+
'Send SMS messages to multiple recipients in your CSV file without writing a single piece of code.',
88+
authorName: 'Acho Arnold',
89+
authorTwitter: 'acho_arnold',
90+
},
6791
{
6892
route: '/blog/send-sms-from-android-phone-with-python',
6993
title: 'Send an SMS from your Android phone with Python',

0 commit comments

Comments
 (0)