Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
googlesheets
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Pipe any Apify dataset into Google Sheets (and read a sheet back as JSON)
William Jin
William Jin
William Jin
Follow
Nov 3
Pipe any Apify dataset into Google Sheets (and read a sheet back as JSON)
#
googlesheets
#
automation
#
api
#
tutorial
Comments
Add Comment
5 min read
Moderation
#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero
SheetError
SheetError
SheetError
Follow
Nov 4
#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
2 min read
Moderation
How to pull Shopify orders into Google Sheets automatically (free Apps Script)
Zahid Thani
Zahid Thani
Zahid Thani
Follow
Nov 2
How to pull Shopify orders into Google Sheets automatically (free Apps Script)
#
googlesheets
#
shopify
#
javascript
#
automation
Comments
Add Comment
4 min read
Moderation
Send WhatsApp Order Updates From Google Sheets With 80 Lines of Apps Script
WAPGROWAI
WAPGROWAI
WAPGROWAI
Follow
for
WAPGROWAI
Nov 2
Send WhatsApp Order Updates From Google Sheets With 80 Lines of Apps Script
#
whatsapp
#
javascript
#
googlesheets
#
tutorial
2
 reactions
Comments
Add Comment
6 min read
Moderation
Stop trusting your Amazon payout number: check the settlement report line by line in Google Sheets
Small Tools Studio
Small Tools Studio
Small Tools Studio
Follow
Nov 2
Stop trusting your Amazon payout number: check the settlement report line by line in Google Sheets
#
googlesheets
#
ecommerce
#
tutorial
#
productivity
Comments
Add Comment
2 min read
Moderation
ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets
SheetError
SheetError
SheetError
Follow
Nov 1
ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
2 min read
Moderation
Track new and closed jobs at any Greenhouse, Lever or Ashby company in Google Sheets
Hiring Signals
Hiring Signals
Hiring Signals
Follow
Oct 30
Track new and closed jobs at any Greenhouse, Lever or Ashby company in Google Sheets
#
googlesheets
#
javascript
#
sales
#
automation
Comments
Add Comment
4 min read
Moderation
Keep bots out of your Google Sheet lead form (honeypot + time trap)
Dovetail Scripts
Dovetail Scripts
Dovetail Scripts
Follow
Nov 3
Keep bots out of your Google Sheet lead form (honeypot + time trap)
#
automation
#
googlesheets
#
javascript
#
webdev
Comments
2
 comments
3 min read
Moderation
Run a Python script on a schedule for free and write the results to Google Sheets (GitHub Actions + gspread)
Žan Mažgon
Žan Mažgon
Žan Mažgon
Follow
Oct 29
Run a Python script on a schedule for free and write the results to Google Sheets (GitHub Actions + gspread)
#
python
#
googlesheets
#
githubactions
#
automation
Comments
Add Comment
6 min read
Moderation
The edge cases that break simple Google Apps Script automations
Noah Federovitch
Noah Federovitch
Noah Federovitch
Follow
Oct 29
The edge cases that break simple Google Apps Script automations
#
googleappsscript
#
googlesheets
#
javascript
#
automation
Comments
Add Comment
2 min read
Moderation
Python + Google Sheets on autopilot: why your script dies after 7 days (and 4 more errors)
Žan Mažgon
Žan Mažgon
Žan Mažgon
Follow
Oct 28
Python + Google Sheets on autopilot: why your script dies after 7 days (and 4 more errors)
#
python
#
googlesheets
#
automation
#
tutorial
Comments
Add Comment
4 min read
Moderation
One polite follow-up when a lead goes quiet (Apps Script)
Dovetail Scripts
Dovetail Scripts
Dovetail Scripts
Follow
Oct 29
One polite follow-up when a lead goes quiet (Apps Script)
#
automation
#
googlesheets
#
gmail
#
javascript
Comments
Add Comment
2 min read
Moderation
VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces
SheetError
SheetError
SheetError
Follow
Oct 28
VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
2 min read
Moderation
5 Make.com + Google Sheets Automations Every Solopreneur Should Steal (Free Walkthrough)
April
April
April
Follow
Oct 27
5 Make.com + Google Sheets Automations Every Solopreneur Should Steal (Free Walkthrough)
#
automation
#
nocode
#
productivity
#
googlesheets
Comments
Add Comment
6 min read
Moderation
Build a monthly client report in Google Sheets with Claude
Or Emergy
Or Emergy
Or Emergy
Follow
Oct 27
Build a monthly client report in Google Sheets with Claude
#
claude
#
googlesheets
#
productivity
#
ai
Comments
Add Comment
5 min read
Moderation
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account