MENU

Fun & Interesting

Master Make.com + Google Sheets (Complete Course)

Smail AI 12,029 lượt xem 8 months ago
Video Not Working? Fix It Now

GET NOW THE MEGAPACK FOR FREE ⤵️
https://discord.gg/Yt9QgjBUMg
It includes: 35+ make.com blueprints, Spreadsheets that I used, useful links to follow along

SUMMARY ⤵️
This is a Full 1h30 Course on how to automate your tasks with Google Sheets using Make.com. This course shows how all Google Sheets modules, and how you can do pretty much anything you want using the Google Sheets API reference.

1-ON-1 PAID CONSULTING ⤵️
https://calendly.com/smail-ai

Do you want to automate the repetitive tasks in your business ? Tasks that don't require brainpower ?
Book an AI and Automation consulting call here:
📅 https://calendly.com/neurafirst/neurafirst

00:00 Intro
02:35 Watch changes
09:51 Watch new rows
13:16 Add a row
14:16 Update a row
15:02 Clear a row
15:21 Delete a row
15:56 Get a cell
16:53 Update a cell
17:20 Clear a cell
17:35 Get range values
19:50 Clear values from a range
20:12 Add a sheet
20:40 Copy a sheet
21:31 Rename a sheet
21:52 Delete a sheet
22:06 Create a spreadsheet
23:01 Create a spreadsheet from a template
25:06 List Sheets
26:32 Search rows
29:52 Search rows (advanced)
32:07 Add a conditional format rule
36:58 Delete a conditional format rule
37:26 Loop over bundles
43:48 Perform a function (and responder)
50:22 API call: Intro
53:12 Google Sheets API explorer
55:20 Sheets API Grid System
58:46 Sheet system
59:35 Sheets API Example 1: Add values
01:06:54 Sheets API Example 2: Colorize background cells
01:12:30 Sheets API Example 3: Make cells in bold
01:14:30 Sheets API Example 4: Add a chart
01:17:44 Sheets API Example 5: Conditional formatting
01:20:58 Sheets API Example 6: Sorting a table
01:23:29 Sheets API Example 7: Export to PDF
01:27:11 Challenge 1
01:27:44 Challenge 2
01:28:49 Outro


WHAT TO WATCH NEXT 🍿
How to Automate THOUSANDS of AI calls: https://youtu.be/MkqxzUEdBzk
Send PDFs with your AI voice bot: https://youtu.be/WKhYPia2oXE
The AI solution 99% of businesses need: https://youtu.be/Lph_rXsYypM
A High Ticket AI system for Lawyers: https://youtu.be/G4yqQShopqM
Easily configure RetellAI: https://youtu.be/c4GPgkHNb6M


Follow me on LinkedIn:
👉🏻https://linkedin.com/in/ialaouiabdellaoui/

The tools I used:
👉🏻Make: https://www.make.com/
👉🏻Google Sheets API: https://developers.google.com/sheets/api/reference/rest


About Me 👋🏼
I'm Smail Alaoui, an AI engineer, entrepreneur, and the founder of NeuraFirst.

I have been in the AI world since 2017, but I recently decided to create this channel to help entrepreneurs use AI to either scale their existing business or to create their own AI agency.

My mission is to leverage my knowledge in AI, business, and software to expand your mind about what is possible in the AI world, and to help you take advantage of the incredible opportunity that is AI.

Let's all together ride the BIG AI 🌊 wave !

Comment