DEV Community

#googlesheets

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to track unpaid invoices in Google Sheets (with automatic overdue status)

How to track unpaid invoices in Google Sheets (with automatic overdue status)

1
Comments
3 min read
n8n AI Agent: Let the Model Fill Your Google Sheets Columns. Make the System Prompt and the Header Row One Schema

n8n AI Agent: Let the Model Fill Your Google Sheets Columns. Make the System Prompt and the Header Row One Schema

Comments
5 min read
FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first

FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first

Comments
2 min read
Track a fixed shopping basket weekly: a saved Task, a schedule and a Sheet

Track a fixed shopping basket weekly: a saved Task, a schedule and a Sheet

Comments
5 min read
Did that cancellation actually work? A cancellation check log in Google Sheets

Did that cancellation actually work? A cancellation check log in Google Sheets

Comments
5 min read
IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip

IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip

Comments 1
3 min read
Send email alerts for overdue dates in Google Sheets via Apps Script

Send email alerts for overdue dates in Google Sheets via Apps Script

1
Comments 1
4 min read
Enrich a list of French SIREN numbers in Google Sheets

Enrich a list of French SIREN numbers in Google Sheets

Comments
4 min read
Google Forms Approvals in Apps Script: When the Requester Approves Their Own Request

Google Forms Approvals in Apps Script: When the Requester Approves Their Own Request

5
Comments
11 min read
Cost a restaurant menu in a spreadsheet: four formulas and one sheet layout

Cost a restaurant menu in a spreadsheet: four formulas and one sheet layout

Comments
2 min read
Outgrown Google Sheets? Count the Slow Formulas Before You Decide

Outgrown Google Sheets? Count the Slow Formulas Before You Decide

5
Comments
9 min read
One Google Sheet, whole lead pipeline: collect, reply, follow up, keep bots out

One Google Sheet, whole lead pipeline: collect, reply, follow up, keep bots out

Comments
3 min read
Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

Comments
2 min read
How to Get LinkedIn Ad Library Data into Google Sheet

How to Get LinkedIn Ad Library Data into Google Sheet

Comments
3 min read
Enrich a column of company websites in Google Sheets with one formula

Enrich a column of company websites in Google Sheets with one formula

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.