Submit by 11 PM IST
Week 1 · Day 1 of 14
Week 1
Day 1 ✓
Day 2 ✓
Day 3 ✓
Day 4 ✓
Day 5 ✓
Day 6 ✓
Week 2
Day 7 ✓
Day 8 ✓
Day 9 ✓
Day 10 ✓
Day 11
Day 12
Week 3
Day 13
Day 14
Day 15
Day 16
Day 17
Day 18
Week 4
Day 19
Day 20
Day 21
Day 22
Day 23
Day 24
Week 5
Day 25
Day 26
Day 27
Day 28
Day 29
Day 30
Week 6
Day 31
Day 32
Day 33
Day 34
Day 35
Day 36
Week 7
Day 37
Day 38
Day 39
Day 40
Day 41
Day 42
Week 8
Day 43
Day 44
Day 45
Day 46
Day 47
Day 48
⚡ Do This Right Now
1
Read the explainer
2
Pass the quiz (3/5)
3
Submit before 11 PM
🕚 Deadline: 11 PM IST
1
Read
2
Quiz 3/5
3
Submit
🕚 11 PM IST
🔒

This task is currently closed.

Day 1 is assigned to a specific date by the WSP team based on your batch start date.

📅 Check your confirmation email for your full task schedule.

Haven't received it? Email hello@wa.expert and we'll sort it out quickly.
📅 Week 1 · Monday
day-01

What is WA.Expert?.

Today you'll learn: what WA.Expert is and why businesses pay for it — explained so clearly you could teach it to your parents by tonight.

⏱ ~20 mins
📖 Read + Quiz + Submit
✅ Need 3/5 to unlock
🔒 Friday only
Week
Week 2 of 8
Day
1 of 14
Program
2-Week Program
📖 Read This First — About 8 Minutes

Google Sheets is the most universally accessible database. Connecting WA.Expert to it unlocks powerful no-code workflows.

Google Sheets is used by almost every SMB as their primary data tool. Connecting WA.Expert to Google Sheets — so leads, submissions, and campaign data flow in automatically — is one of the highest-value, lowest-complexity integrations you can build for clients.

Today you are implementing three Google Sheets integrations: lead capture, form submission logging, and campaign analytics. Each uses a different connection pattern but the same no-code approach.

📊
Google Sheets as an operations dashboard: every WhatsApp lead, every form submission, every campaign metric flowing in automatically. The client wakes up and their entire WhatsApp operation's overnight activity is already logged, sorted, and visible. That is what this integration delivers.
📥
Lead capture sheet
Chatbot or Flow collects lead → webhook fires → Make.com receives → new row added with: name, phone, source, qualification data, timestamp, CRM tags. Real-time lead log.
📝
Form submission log
Any submission (task, appointment, feedback Flow) → webhook → Sheets row. Submission ID, user ID, content, timestamp. Audit trail for all submissions.
📊
Campaign analytics sheet
Daily export from WA.Expert API → Make.com → Sheets: delivery rate, read rate, click rate, opt-out rate per campaign. Performance dashboard in Sheets.
🔔
Conditional automation
Google Sheets formula + Make.com: if lead score exceeds threshold → trigger WA.Expert API to send follow-up WhatsApp. Sheets becomes part of the automation logic.

🔑 Sheet design principle: Design the Google Sheet BEFORE building the integration. Columns defined, headers matching webhook field names exactly, formulas set up in advance. Building into a poorly designed sheet creates more work than starting over.

💡
Read the reference page below before taking the quiz.
📊
Explore: Google Sheets Integrationwa.expert/pages/whatsapp-google-sheets-integration.html · Integration guide · ~5 mins
→
🧠 Quiz — 5 Questions
🧠
Day 1 Quiz
Score 3 or more to unlock your submission. Retry as many times as you want — every wrong answer tells you why.
5 questions Need 3/5 Unlimited tries Instant feedback
Question 1 of 5
Why is Google Sheets a particularly good database for small business WA.Expert integrations?
A
It is the cheapest database available
B
Universally familiar to non-technical teams, zero database administration, real-time multi-user access, and powerful API that Make.com and Apps Script connect to trivially
C
It can store unlimited data without slowdown
D
It has built-in machine learning
✅ Familiarity + accessibility + no admin overhead. Non-technical teams interact with data directly without training. Make.com and Apps Script connect trivially.
❌ Familiarity and accessibility are the key advantages. Non-technical teams can work with it immediately. Zero admin. Make.com connects trivially.
Question 2 of 5
What should be defined BEFORE building the Make.com flow for a lead capture integration?
A
The background colour of the sheet
B
All column headers matching exactly the webhook payload field names, column order, formula columns (e.g. lead score), and access permissions
C
How many rows the sheet will need
D
The chart types for reporting
✅ Sheet design first, integration second. Column headers must match webhook field names exactly for automatic population. Build the integration into a ready sheet.
❌ Sheet design before integration build. Column headers = webhook field names. Formula columns pre-set. Build into a designed sheet, not a blank one.
Question 3 of 5
Make.com automation watches a WA.Expert webhook for new leads. The webhook fires at 2 AM. Client checks sheet at 9 AM. What do they see?
A
Nothing — Make.com only runs during business hours
B
All leads received overnight, already in new rows with all fields filled. Make.com processed webhooks in real time, 24/7, without any human involvement.
C
A notification that manual data entry is needed
D
Only leads from Make.com's scheduled run time
✅ Real-time, 24/7. Make.com processes webhooks the moment they arrive. Every lead that came in overnight is already in the sheet at 9 AM. No gaps.
❌ Real-time 24/7. Make.com processes immediately, any time. The sheet at 9 AM reflects everything that happened overnight.
Question 4 of 5
Coaching institute wants: when 'Trial Class Attended' column is marked YES, automatically send a WhatsApp enrolment offer. How?
A
Manually trigger the WhatsApp when you see YES
B
Google Sheets trigger (cell value changes to YES) → Make.com scenario activates → calls WA.Expert POST /v1/messages with enrolment offer template to that lead's phone
C
This is not possible without custom code
D
Build a chatbot that monitors the sheet
✅ Sheets change trigger → Make.com → WA.Expert API. No code. The sheet becomes part of the workflow logic. Cell change → WhatsApp sent.
❌ Sheets trigger → Make.com → WA.Expert API is the no-code answer. Cell change triggers a Make.com scenario that calls the send message endpoint.
Question 5 of 5
Client asks: 'Can our marketing team update the Sheets lead database without breaking the integration?'
A
No — they should never touch the sheet
B
Yes — with one rule: never change or delete the column headers (integration mapping depends on them). Adding rows, formulas, or new columns to the right is completely safe.
C
Only the developer can access the sheet
D
They need to rebuild the integration after every change
✅ Headers are sacred, everything else is flexible. Column headers are the mapping between webhook data and sheet columns — change them and the integration breaks. Everything else is safe.
❌ Protect the headers. Column headers map webhook fields to sheet columns — change them and the integration breaks. Adding rows, formulas, or new columns to the right is always safe.
–of 5
Answer all 5 questions, then check your score.
✏️ Your Task
🔒

Score 3/5 to unlock this

Complete the quiz above first. The moment you score 3 or more, this section unlocks.

🏅

🎉 Day 1 — done!

Day 2 opens on your assigned Tuesday.

📝 Today's Task
Someone in your family runs a small business. In 3–4 sentences, explain WA.Expert to them like you're actually WhatsApp-ing them right now. Your own words — not copied from the page.
Start like this: "So there's this platform I was reading about — it's basically for businesses that get too many WhatsApp messages to handle manually. It lets them..."
0 / 800
From your registration confirmation email. Can't find it?
Submitting before 11 PM IST on your assigned Friday counts as Day 11 complete.
Week 1 · Coming Tomorrow
Day 2 — WhatsApp App vs Business API Opens Tuesday on your assigned date.
Day 2 →
WSP · WA.Expert Student Programs · wa.expert Help: hello@wa.expert
📋 Register a friend 🎁 Share your WSP ID