A collection of articles and blog posts on the topic of Google Sheets by Amit Sarda.
Looking for alternatives to Fivetran? Discover 4 powerful Fivetran alternatives — Coupler.io, Conduit, Coefficient, and Flatly — for simpler, more affordable data pipelines.
Looking for alternatives to StitchData? Discover 4 powerful StitchData alternatives — Coupler.io, Conduit, Coefficient, and Flatly — for simpler, more affordable data pipelines.
Learn how to create barcodes in Google Sheets using Barcode Fonts and how to build a barcode generator using Google Sheets and Glide Apps.
Learn how to sum up Checkboxes in Google Sheets in to a separate column to create summaries and aggregate data for analysis.
Learn how to guess genders based on the name of the person using Google Sheets and using automation & APIs.
Learn how to find and highlight duplicates in Google Sheets using conditional formatting to clean your data.
Learn how to automatically apply formulas to new rows in Google Sheets across multiple columns using Google Apps Script.