Learn essential Google Sheets skills with our curated collection of tips, tricks, and step-by-step tutorials. From basic formulas to advanced data analysis, discover how to make the most of this powerful spreadsheet tool.
1. How to Unsubscribe from Mailing Lists and Newsletters in Gmail
2. How to Import Data from One Google Sheet to Another - Learn with Practical Examples
3. How to Automatically Format Google Form Responses in Google Sheets
4. How to Export WooCommerce Customers to Google Sheets
5. Send Personalized Emails with SMTP and Mail Merge in Google Sheets
6. How to Extract Email Addresses from Gmail Messages
7. How to Add Password to PDF Documents in Google Drive
8. How to Email Screenshots of Google Sheets on a Schedule
9. How to Create Multiple Sub-folders in Google Drive Automatically
10. How to Send Email Reminders for Google Forms Automatically
11. How to Automatically Rename Files in Google Drive with Apps Script and AI
12. The Best Google Add-ons for Docs, Sheets, Slides and Google Forms
13. Monitor Your Stock Portfolio with Google Sheets and Receive Daily Email Reports
14. How to Mail Merge with Outlook and Google Sheets
15. How to Create Personalized Images in Bulk with Google Sheets
16. Emojis in Google Sheets
17. How to Link Postal Addresses to Google Maps in Google Sheets
18. How to Email Google Sheets Automatically on a Recurring Schedule
19. Google Maps Formulas for Google Sheets
20. Create a BMI Calculator using Google Forms and Google Sheets
21. How to Transcribe Audio and Video Attachments in Gmail
22. How to Sort Google Sheets Automatically with Apps Script
23. Find Free Udemy Courses with Google Sheets and the Udemy API
24. How to Use Conditional Logic in Google Documents
25. How to Make Phone Numbers Callable in Google Sheets and Docs
26. Convert Google Docs and Google Sheets with Apps Script
27. Formulas in Google Sheets Disappear When New Rows Are Added - The Solution
28. How to Send Personalized Text Messages from Google Sheets
29. How Teachers can Email Parents of Students from Google Forms
30. How to Make Personalized Place Cards with Guest Names
31. Color Codes for Google Spreadsheets
32. Send WhatsApp Messages with a Google Sheets Function
33. How to Send WhatsApp Messages from Google Sheets using the WhatsApp API
34. How to Open a Website in New Window from Google Sheets Menu
35. How to Play an MP3 File in Google Sheets
36. How to Auto-Download Podcasts to Google Drive with Google Sheets
37. How to Generate Dynamic QR Codes to Collect Payments through UPI
38. How to Use Conditional Formatting in Google Sheets to Highlight Information
39. How to Insert Images in Google Sheet Cells
40. How to Send SMS Messages with Google Sheets and Android Phone
41. How to Import PayPal Transactions into Google Sheets
42. How to Get the Last Row in Google Sheets when using ArrayFormula
43. How to Extract URLs from HYPERLINK Function in Google Sheets
44. How to Use Hyperlinks in Google Sheets
45. How to Create Dynamic Open Graph Images with Google Sheets
46. How to Request Stripe Payments with Google Sheets
47. Convert and Email Google Spreadsheets as PDF Files
48. How to Change the Date Format in Google Sheets
49. Find Product Prices in Google Sheets with Vlookup and Match Functions
50. How to Request Payments with Razorpay and Google Sheets
51. Essential Date Functions for Google Sheets
52. How to Use Notion with Gmail and Google Sheets using Apps Script
53. Sort by Random - How to Randomize the Order of Rows in Google Sheets
54. How to Replace Accented Characters (diacritics) with English letters in Google Sheets
55. How to Convert Column Number (e.g. 28) to Column Letter (e.g. AB) in Google Sheets
56. Google Sheets - Find Values in One Column that are Missing in Another Column
57. How to Add Options in Google Forms Questions from Google Sheets
58. How to Perform IP Address Lookup with Google Sheets
59. How to Copy a Formula Down an Entire Column in Google Sheets
60. How to Use Formulas with Google Form Responses in Sheets
61. How to Preserve Formatting of Spreadsheet Cells in Mail Merge
62. How to Highlight Duplicates in Google Sheets and Remove
63. Measure Core Web Vitals of your Websites with Google Sheets
64. How to Use Google Sheets with D3.js and Google Visualization
65. How to Make Pixel Paintings with Google Spreadsheets
66. How to Get Hidden and Filtered Rows in Google Sheets with Google Script
67. Convert Numbers to Words using Indian Numbering in Google Sheets
68. Track Coronavirus (COVID-19) Cases in India with Google Sheets
69. How to Import MailChimp Subscribers to Google Sheets
70. How to Scrape Reddit with Google Scripts
71. How to Color Alternate Rows in Google Sheets
72. Get the Form Edit Response URL in Google Sheets
73. How to Track your Study Time with Google Forms and Sheets
74. Save Gmail Messages to a Google Spreadsheet
75. How to Track Google Spreadsheet Views with Google Analytics
76. How to Make YouTube Playlists with a Google Spreadsheet
77. Find Duplicate Rows in Google Sheets
78. How to Import Web Data into Google Sheets
79. Build a Web Page Monitor with Google Sheets using ImportXML
80. Screen Scraping the Google Play Store with Google Sheets
81. How to Write JSON to a Google Spreadsheet
82. Convert Word, Excel and PowerPoint files to Google Docs with Google Script
83. Save Paypal Email Receipts in Google Spreadsheet
84. Build a Charts Dashboard with Google Sheets and HTML Service
85. How to Create Personalized Documents from a Google Spreadsheet in Minutes
86. Fill Google Spreadsheet with Random Data
87. How to Import CSV Files into Google Spreadsheets with Google Apps Script
88. Convert Excel Files to CSV in Google Drive with Apps Script
89. How to Email a Range of Google Spreadsheet Cells
90. Export Formulas and Notes from a Google Spreadsheet
91. Search Books with Goodreads API and Google Apps Script
92. Send Gravity Forms Data to Google Spreadsheet or Email
93. Get Google Spreadsheets Data as JSON in your Website
94. Reorder Worksheets in Google Spreadsheets by Name
95. How to Update Multiple Cell Values in Google Sheets with Apps Script
96. How to Convert Microsoft Excel to Google Spreadsheet Format with Apps Script
97. Parse XML RSS Feeds with Google Scripts
98. Copy Google Spreadsheet Data to another Sheet with Apps Script
99. A Custom Google Spreadsheet Function for Tracking Pageviews
100. Save Google Sheet as JSON
101. Publish Google Spreadsheets as JSON with Apps Script
102. Find Matching Rows in Google Spreadsheets
103. Export your Fitbit Data in a Google Spreadsheet
104. Get QuickBooks Data into Google Sheets with Apps Script
105. Merge Multiple Google Spreadsheets into One
106. Get Email Notifications for Edits in Google Spreadsheet
107. Duplicate a Sheet in Google Spreadsheets
108. Convert Google Sheet to Excel XLSX Spreadsheet
109. Send Personalized Tweets & DMs in Bulk from a Google Spreadsheet
110. How to Scrape Google Search Results inside a Google Sheet
111. Send Self-Destructing Messages with Google Docs
112. Find and Remove Duplicate Rows in Google Sheets
113. Google Tables for Viewing Large Excel Spreadsheets on the Web
114. How to Publish Google Sheets Directly as PDF or Excel Files