Google Sheets invoice template: build one that tracks payment
Create a polished invoice, calculate totals correctly, and keep sent, due and overdue invoices visible in one dependable sheet.
Published July 26, 2026 · Updated July 27, 2026
AUTHORPhilis
Spreadsheet reviewer at SheetSteps
Philis writes and checks SheetSteps articles about data cleanup, charts, web imports and team workflows.
ARTICLES
Written by Philis
How to create a table in Google Sheets
Structure raw data with headers, types, filters and totals so sorting and formulas keep working as the sheet grows.
Published July 24, 2026 · Updated July 27, 2026
How to merge cells in Google Sheets—and when not to
Merge titles and presentation blocks safely while keeping tables sortable, filterable and formula-friendly.
Published July 22, 2026 · Updated July 27, 2026
How to use VLOOKUP in Google Sheets
Look up an ID, return the matching entry and fix the range, index and exact-match mistakes behind most VLOOKUP errors.
Published July 20, 2026 · Updated July 27, 2026
How to use IMPORTRANGE in Google Sheets
Pull a reliable range from another spreadsheet, grant access once and combine it with QUERY without creating a fragile chain.
Published July 18, 2026 · Updated July 27, 2026
How to use AI in Google Sheets for real work
Classify, extract, summarize and generate across rows while keeping prompts, outputs and costs predictable.
Published July 16, 2026 · Updated July 27, 2026
How to build a Google Sheets dashboard people can read
Turn a clean source table into a compact operating view with trustworthy KPIs, filters and charts.
Published July 14, 2026 · Updated July 27, 2026
Google Sheets formulas: the practical guide to writing them correctly
Learn the parts of a formula, how cell references behave and how to check a result before filling it down.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets Gantt chart template: plan work on a real timeline
Turn tasks, owners, dates and status into a timeline that the team can update.
Published June 11, 2026 · Updated July 27, 2026
Google Sheets assignment tracker for classes and deadlines
Track classes, due dates, grades and overdue work in one compact student sheet.
Published June 13, 2026 · Updated July 25, 2026
How to search in Google Sheets
Find text, numbers and formulas in one sheet or the full workbook.
Published June 15, 2026 · Updated July 27, 2026
How to add a column in Google Sheets
Insert one or several columns without losing formulas, formatting or filters.
Published June 17, 2026 · Updated July 25, 2026
How to subtract in Google Sheets
Subtract cells, dates and fixed amounts with formulas that copy correctly.
Published June 19, 2026 · Updated July 27, 2026
Google Sheets percentage formulas for totals, growth and discounts
Calculate a share of total, percentage growth, discounts and percentage-point differences.
Published June 21, 2026 · Updated July 25, 2026
IMPORTHTML in Google Sheets: import tables and lists from a page
Pull a public HTML table or list into cells and fix the most common index mistakes.
Published June 23, 2026 · Updated July 27, 2026
How to use IMPORTXML in Google Sheets
Extract page titles, headings, links and table cells with a tested XPath.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets conditional formatting not working: 8 checks
Repair rule ranges, custom formulas, date checks and rule order when cells do not format.
Published June 11, 2026 · Updated July 27, 2026
Google Sheets SUM that ignores errors
Total a range containing errors without deleting the source rows.
Published June 13, 2026 · Updated July 25, 2026
How to make a dropdown in Google Sheets
Create a fixed list, set invalid-data behavior and apply it to future rows.
Published June 15, 2026 · Updated July 27, 2026
How to filter in Google Sheets
Show only matching rows, save personal filter views and avoid changing what teammates see.
Published June 17, 2026 · Updated July 25, 2026
SUMIFS in Google Sheets: sum with several conditions
Total entries by date, owner, status or category with aligned ranges.
Published June 19, 2026 · Updated July 27, 2026
XLOOKUP in Google Sheets: cleaner exact-match lookups
Look up IDs, return entries from either side and set a clear not-found result.
Published June 21, 2026 · Updated July 25, 2026
Google Sheets inventory template with reorder warnings
Track stock, unit cost, reorder points and incoming quantities in one file.
Published June 23, 2026 · Updated July 27, 2026
Loan amortization schedule in Google Sheets
Split each payment into interest and principal and track the remaining balance.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets content calendar for planning and publishing
Plan titles, channels, owners, dates and production status in one schedule.
Published June 11, 2026 · Updated July 27, 2026
IMPORTHTML not working? Use SheetSteps AI to extract the page instead
Diagnose the formula error, then extract the same page with SheetSteps AI when Google cannot read the table or the page needs JavaScript.
Published July 20, 2026 · Updated July 28, 2026
How to refresh web data with a SheetSteps AI batch
Replace volatile formula churn with deliberate refresh jobs, cached results, timestamps and clear edit tracking.
Published July 22, 2026 · Updated July 28, 2026
How to import public API data with SheetSteps AI
Turn JSON responses into stable columns, handle pagination and errors, and avoid exposing API credentials in cells.
Published July 24, 2026 · Updated July 28, 2026
How to extract titles and meta descriptions with SheetSteps AI
Audit URL metadata in bulk with final URLs, status codes, canonical tags and clear missing-field states.
Published July 26, 2026 · Updated July 28, 2026
SHEETSTEPS_TITLE: extract page titles into Google Sheets
Collect one title per URL for an SEO audit, research list or content inventory.
Published July 13, 2026 · Updated July 28, 2026
SHEETSTEPS_H1: extract the primary heading from every URL
Collect the first H1 from public pages and compare it with each page title.
Published July 15, 2026 · Updated July 28, 2026
SHEETSTEPS_LINKS: extract webpage links into spreadsheet rows
Return page links as a spill table for link research, prospecting and SEO inspection.
Published July 17, 2026 · Updated July 28, 2026
SHEETSTEPS_PAGE_DATA: audit core page metadata with one formula
Return a compact page-data object containing common SEO and document fields.
Published July 19, 2026 · Updated July 28, 2026
SHEETSTEPS_SCHEMA: extract JSON-LD from webpages
Read public JSON-LD schema into Google Sheets for product, article, organization or local-business audits.
Published July 21, 2026 · Updated July 28, 2026
SHEETSTEPS_WEB_EXTRACT: extract custom fields from any public page
Describe the fields you want and return an organized object using hosted scraping plus your selected AI execution mode.
Published July 23, 2026 · Updated July 28, 2026