Website Technology Profiler

{
  "PageContent": "<h3>Google Sheets and Apps Script Tutorials and Online Courses</h3>Google Sheets has changed a lot in the past couple of years, with new Tables to keep data structured, Gemini AI to build formulas and analyze data, and modern functions like LET, LAMBDA, and VSTACK that make work faster and smarter. Modern Google Sheets is my brand new online course that shows you how to work faster and smarter with Google Sheets in the age of AI.Inside the course, you’ll find:Step-by-step lessons on all the latest features, including Tables, Gemini AI, and modern functionsDownloadable templates for every lessonBest practices for clean data, AI prompting, and great visualsA real-world automation case study to tie it all togetherArticles:AI and SpreadsheetsHow to use the AI Function in Google Sheets (with 10 examples)I Let OpenAI Operator Manage My Google Sheet: Here’s What Happened.Can AI Studio teach me how to build a pivot table?AI Experiments: Using Sora AI to Generate VideosWhat AI Can Do For You As A Google Sheets User. Is The Hype Justified?Three Ways To Use AI Tools With Google SheetsHow I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey ResponsesGoogle Sheets ArticlesPopular ArticlesHow to use Google Sheets: A Beginner’s Guide(a super detailed guide to take you from newbie to ninja in no time!)11 Incredibly Useful URL Tricks for Google SheetsHow to apply conditional formatting across an entire row in Google SheetsChecklist Template In Google SheetsGoogle Sheets Query function: The Most Powerful Function in Google SheetsFiltering with dates in the QUERY functionWhen Your Formula Doesn’t Work: Formula Parse Errors in Google SheetsGoogle Apps Script: A Beginner’s GuideAdd A Google Sheets Button To Run ScriptsHow To Add Subscript and Superscript In Google SheetsGoogle Sheets Custom Number FormatCustom Number Format Color Palette Reference TableHow To Use Checkboxes In Google SheetsSheets Insiders Membership ArticlesIntroducing The Sheets Insiders Membership ProgramSheets Insiders 1: Visual Vocabulary Template (available to everyone)Working with data in Google SheetsThe Complete Guide to Tables in Google SheetsHow To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To AnotherSlow Google Sheets? Here are 27 ideas to try today18 best practices for working with data in Google SheetsHow To Copy Only Visible Cells In Google SheetsHow To Use Checkboxes In Google SheetsHow To Create A Select All Checkbox in Google SheetsHow To Mimic Radio Buttons With Formulas and CheckboxesHow To Create A Google Sheets Drop Down MenuMultiple Selections in Drop Downs in Google SheetsHow to Remove Duplicates in Google SheetsUnpivot In Google Sheets With Formulas, Or How To Turn Wide Data Into Tall DataConnected Sheets: Analyze Big Data In Google SheetsBeyond Sheets: Get Started With Google BigQueryGet A Unique List Of Items From A Column With Grouped WordsHow To Highlight The Top 5 Values In Google Sheets With FormulasHow To Rank Data In Google Sheets With The RANK FunctionHow To Create Arrays In Google Sheets (a.k.a. Array Literals)Automatic Data Sharing Across Sheets With IMPORTRANGE and Named FunctionsFormulas in Google Sheets11 New Analytical Functions In Google Sheets For 2023New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc.A Guide To Named Functions In Google SheetsLAMBDA Function in Google SheetsXLOOKUP Function in Google SheetsXMATCH Function in Google SheetsMAP Function in Google Sheets – LAMBDA Helper FunctionREDUCE Function in Google Sheets – LAMBDA Helper FunctionMAKEARRAY Function in Google Sheets – LAMBDA Helper FunctionSCAN Function in Google Sheets – LAMBDA Helper FunctionBYROW Function in Google Sheets – LAMBDA Helper FunctionBYCOL Function in Google Sheets – LAMBDA Helper Function18 Google Sheets Formula Tips &amp; Techniques You Should KnowUse The Onion Method To Approach Complex FormulasIF Function in Google SheetsIFS Function in Google SheetsIFERROR Function In Google SheetsFACT Function in Google Sheets (And Why A Shuffled Deck of Cards Is Unique)REPT Function in Google SheetsSPLIT Function in Google SheetsINDIRECT Function in Google SheetsSUBTOTAL Function in Google SheetsGoogle Sheets Query function: Learn the most powerful function in Google SheetsFiltering with dates in the QUERY functionHow to add a total row to a Query Function table in Google SheetsA Guide To The Google Sheets Filter FunctionAdvanced Filter Examples in Google SheetsHow does the array formula work in Google Sheets?Use Array Formulas to auto-fill calculation columns when using Google FormsHow can I combine text and numbers in a cell and keep the number formatting?How do I get the first and last days of the current month?How do I get the first and last days of the prior month?VLOOKUP Function in Google Sheets: The Essential GuideHow do I do a VLOOKUP to the left in Google Sheets?VLOOKUP in Google Sheets using wildcards for partial matchesHave VLOOKUP Return Multiple Columns in Google SheetsVLOOKUP Multiple Criteria in Google SheetsRunning Total Array Formulas (using MMULT)How do I reverse text in a cell in Google Sheets?Build Numbered Lists With The Amazing SEQUENCE FunctionHow to create dynamic named ranges in Google SheetsHelp, my formula doesn’t work! (Dealing with errors)Experiments With Cell Function: Create A Dynamic Table Of Contents In Google Sheets With FormulasGoogle Sheets REGEX FormulasSetting Default Values For Cells In Google SheetsA Complete Guide To The CHAR Function In Google SheetsThe TRANSPOSE Function in Google SheetsThe FLATTEN Function in Google SheetsThe AND Function in Google SheetsThe OR Function in Google SheetsThe UNIQUE Function in Google SheetsGoogle Sheets COUNTIF FunctionGoogle Sheets COUNTIFS FunctionHow To Use Google Sheets SUMIF FunctionGoogle Sheets SUMIFS FunctionHow To Use The RANDARRAY Function In Google SheetsHow To Use The RANDBETWEEN Function In Google SheetsHow To Create A Random Number Generator In Google SheetsSORTN Function In Google SheetsThe LARGE Function in Google SheetsUse The SWITCH Function to Categorize Data EfficientlyHow To Use The Choose Function In Google SheetsHow To Use The TRIM Function In Google Sheets To Clean Your DataThe ROMAN Function in Google SheetsThe LEN Function in Google SheetsGETPIVOTDATA Function in Google Sheets: How To Extract Data From Pivot TablesBullet Chart in Google Sheets with Sparklines and Named FunctionsRecursion in Google Sheets with FormulasFormula Challenges in Google SheetsFormula Challenge #1: Repeating Images with Array FormulasFormula Challenge #2: Matching TermsFormula Challenge #3: Alphabetize Comma-Separated StringsFormula Challenge #4: Sort A Column By Last NameFormula Challenge #5: Merge Columns in Google Sheets With Single Range ReferenceFormula Challenge #6: Split A String Into Characters And Recombine In Random OrderFormula Challenge #7: Generate A Repeating Sequence Of NumbersGetting external data into Google Sheets with formulasAlexa Rank Tracker in Google SheetsUsing Google Sheets as a basic web scraperHow can I import social media statistics into Google Sheets?Pivot Tables in Google SheetsPivot Tables in Google Sheets: A Beginner’s GuideMapping data with Pivot Tables in Google Sheets…yes, really!Slicers in Google SheetsFormatting in Google SheetsHow To Add Subscript and Superscript In Google SheetsHow To Merge Cells In Google Sheets And When To Be CarefulHow To Apply Conditional Formatting Across An Entire Row In Google SheetsStatus Arrows in Google SheetsUsing Text Rotation to Create Custom Table Headers in Google SheetsGoogle Sheets Custom Number FormatHow To Wrap Text In Google SheetsCreate Barcodes In Google Sheets In 2 Easy StepsHow To Create QR Codes in Google Sheets Using FormulasHow To Alternate Colors In Google SheetsAutomationThe complete guide to simple automation in Google Sheets, using MacrosData Analysis techniques in Google SheetsGoal Seek in Google SheetsWhat the world’s richest man can teach us about averagesCharting techniques in Google SheetsRadial Bar Charts in Google SheetsHow To Create A Grid Chart In Google SheetsCreating dynamic charts using Google Sheets drop down menusEverything you ever wanted to know about Sparklines in Google SheetsHow can I format individual data points in Google Sheets charts?How to create an annotated line graph in Google SheetsHow to create a funnel chart in Google SheetsHow to create a waterfall chart in Google SheetsWeb traffic chart with dynamic banding in Google SheetsHow do I create a multi-colored line chart in Google Sheets?How to Create a Scatter Plot in Google SheetsHow to make a Histogram in Google Sheets and overlay a Normal Distribution CurveDot Plots in Google SheetsHow To Create A Heat Map In Google SheetsBullet Chart in Google Sheets with Sparklines and Named FunctionsFormula Pie Charts in Google SheetsDashboards in Google Sheets10 techniques for building a Google Sheets dashboardDashboard Design Checklist: From a Blank Google Sheet to Business Insights10 techniques to use when building budget templates in Google SheetsHow to build a real-time sales dashboard for E-junkie using Google Sheets and Apps ScriptBuilding a dynamic dashboard for a 3-day digital flash saleCreating a custom Google Analytics report in a Google spreadsheetCreating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launchMaking Google Sheets look less like… Google SheetsOther articles about Google SheetsThe Complete Guide to Smart Chips in Google SheetsHow I Built A Glide App And Turned My Google Sheet Into A Simple No-Code AppHow we manage our family finances with Google SheetsExplaining syntax differences in your formulas due to your Google Sheets location6 Killer Productivity Tips for Google SheetsMathematics in Google SheetsExploring Population Growth And Chaos Theory With The Logistic Map, In Google SheetsHow To Draw The Cantor Set In Google SheetsPI Function in Google Sheets And Other Fun π FactsComplex Numbers In Google SheetsHow To Draw The MandelBrot Set In Google Sheets, Using Only FormulasHow To Draw The Sierpiński Triangle In Google SheetsThe FACT Function in Google Sheets (And Why A Shuffled Deck of Cards Is Unique)Recursion and the Fibonacci SequenceRecursion, Primes and the Sieve of EratosthenesExploration With Google SheetsInteresting projects that push the limits of what you can do in Google Sheets, without coding.Play-It-Through Chess Game in a Single Google Sheets FormulaEtch A Sheet In Google SheetsGoogle Sheets Formula ClockRecreating Visualize Value design work with SPARKLINES (external link to Twitter)Google Sheets Advent CalendarJoin The Dots Drawing In Google SheetsOther Resources for Google SheetsExcel To Sheets — a dedicated resource to help organizations migrate to Google Sheets from Microsoft Excel.How To Become A Freelance Google Sheets DeveloperGoogle Sheets CoursesGoogle Sheets Essentials (beginner course)Data Analysis in Google SheetsBuild Dashboards with Google SheetsPivot Tables in Google SheetsThe Google Sheets REGEX Formula CookbookAdvanced Formulas – 30 Day Challenge (a free course)Apps Script ArticlesGetting Started Guides for Apps ScriptThe complete guide to simple automation in Google Sheets, using MacrosGoogle Apps Script: A Beginner’s GuideRepeatable Task: To Script Or Not To Script, That Is The QuestionA Guide To The New Google Apps Script IDEAPI Tutorial For Beginners With Google Sheets &amp; Apps Script10 Coding Tips For Beginners With Apps ScriptAdd A Google Sheets Button To Run ScriptsFinding Merged Cells In Your Google Sheet using Apps ScriptSheet Sizer! Build A Tool To Measure Your Google Sheets Size With Apps ScriptUsing Apps Script to automate Google WorkspaceRadio Buttons in Google Sheets: Only One Checkbox CheckedGoogle Sheets Sort By Color And Google Sheets Filter By ColorHow To Save Data In Google Sheets With Timestamps Using Apps ScriptHow to set up time-based triggers to run your Apps Script codeHow to add a hyperlinked index sheet or sidebar to your large Google Sheet workbooksHow to extract email addresses tagged with a specific Gmail labelGmail Mail Merge For A Specific Label With Apps ScriptHow to reply to Google Forms survey responses quickly with Sheets &amp; Apps ScriptHow to automatically create waterfall charts using Apps ScriptHow to automatically create funnel charts using Apps ScriptOne way to animate a chart in Google SheetsWorking with external services using Apps ScriptAPI Authentication Apps Script ReferenceHow To Build An Automated ConvertKit Report In Google Sheets Using Apps ScriptHow To Connect To The Teachable API With Apps ScriptHow To Get Fathom Analytics Data Into Google Sheets, Using Apps ScriptControl Your Nest Thermostat And Build A Temperature Logger In Google Sheets Using Apps ScriptSentiment Analysis For Google Tables Using Apps ScriptData Enrichment with the Google Tables Apps Script Bot (Mattermark API)How to connect the Strava API with Google Sheets and Data StudioGoogle Sheets Slack bot: how to push data from your Google Sheets into the popular messaging appConnecting to the Crunchbase API with Google SheetsGoogle Sheets and Mailchimp integration using Apps ScriptShow data from the GitHub API in Google Sheets, using Apps Script and OauthHow to build a real-time sales dashboard for E-junkie using Google Sheets and Apps ScriptUsing Slack Slash Commands to Send Data from Slack into Google Sheets (guest post on external site)How to create a Data Studio Community Connector with Apps ScriptHow To Connect Google Sheets To A Database, Using Apps ScriptD3 and Google Chart APIGoogle Sheets and D3 chartsRecreating Tufte’s famous temperature chart with the Google Chart APIAnimated temperature chart using the Google Chart APIOther Apps Script ResourcesHow To Track Link Clicks With Apps Script And Google SheetsApps Script V8 Runtime Is Here! What Does That Mean?Check out my apps script and apps script API repositories on GitHub.Apps Script CoursesApps Script Taster: a free, introductory courseBeginner Apps Script: a fun and practical way to master the foundations of Apps ScriptAutomation With Apps Script: learn how to automate workflows in Google Workspace and work with external APIs🔧 Other Google Tools I Work WithGoogle TablesTable’s features and capabilities are now integrated into AppSheet. Read more here.Google Tables: How I Use Google’s New Workflow ToolSentiment Analysis For Google Tables Using Apps ScriptData Enrichment with the Google Tables Apps Script BotGoogle BigQueryBeyond Sheets: Get Started With Google BigQueryLooker (formerly Data Studio) ArticlesAn introduction to Data StudioHow to connect the Strava API with Google Sheets and Data Studio6 advanced techniques in Data StudioCommunity connectors to access any data in Data StudioData Studio Connector fields get an updateGoogle SitesHow to Use Google Sheets in Your Google Sites📚 Other articlesAnnual Reviews2025 In Review And A Look Forward To 20262024 In Review And A Look Forward To 20252023 In Review And A Look Forward To 20242022 In Review And A Look Forward To 20232021 In Review And A Look Forward To 20222020 In Review And A Look Forward To 20212019 in review and a look forward to 20202018 in review and a look forward to 20192017 in review and a look forward to 20182016 in review and a look forward to 20172015 in review and a look forward to 2016SheetsCon: Online Google Sheets ConferenceSheetsCon 2020: Lessons Learned Running An Online Conference For 6,700 PeopleGoogle Cloud Next Conference RecapsRecap From Google Cloud Next ’19 ConferenceGoogle Next 19 Conference – Live BlogRecap From Google Cloud Next ’18 ConferenceEssaysA Behind The Scenes Look At How I Create A Technical Video CourseThree Benefits Of Cohort-Based Courses5 Insights From Taking A Live Cohort-Based Course (And How I’m Applying Them To My Own)Create A Student Learning Loop In Your Cohort-Based CourseI Left My Corporate Accounting Job 7 Years Ago. Here’s How I Built A Career As An Educational EntrepreneurThoughts on productivityIn Pursuit Of A DreamIf Google Sheets And Microsoft Excel Went For A Drink…Dream Home Office SetupSQLSix reasons to start learning SQLHow To Connect Google Sheets To A SQL Database, Using Apps ScriptExcelExcel tutorial: build a dynamic bump chart of the English Premier LeagueExcel tutorial: Building a dynamic, animated dashboard for U.S. political dataExcel-fficiency: 10 tips for boosting productivity in Excel",
  "Url": "https://www.benlcollins.com",
  "IpAddress": "141.193.213.10",
  "ReverseDns": null,
  "Asn": null,
  "Http2": false,
  "Http3": false,
  "ResponseTimeMs": 359,
  "StatusCode": 200,
  "ServerHeaders": [
    "cloudflare",
    "WP Engine"
  ],
  "Ssl": {
    "Issuer": "CN=E7, O=Let's Encrypt, C=US",
    "Subject": "CN=www.benlcollins.com",
    "NotBefore": "2025-12-26T08:25:23-08:00",
    "NotAfter": "2026-03-26T09:25:22-07:00",
    "SubjectAltNames": [
      "DNS Name=www.benlcollins.com"
    ],
    "Hsts": false,
    "Ciphers": [],
    "Protocol": "Tls13",
    "DaysUntilExpiry": 54
  },
  "Cdns": [
    "Cloudflare"
  ],
  "HostingHints": [],
  "Cms": [
    "WordPress"
  ],
  "Frameworks": [
    "jQuery"
  ],
  "JsLibraries": [],
  "Analytics": [
    "Google Analytics GA4",
    "Fathom"
  ],
  "AdsAndMarketing": [],
  "PaymentGateways": [],
  "EcommerceHints": [
    "PrestaShop"
  ],
  "SocialSignals": [],
  "MediaProviders": [],
  "SeoTags": [
    "content-type: text/html; charset=UTF-8"
  ],
  "HtmlLanguage": "en-US",
  "HasRobots": true,
  "HasSitemap": true,
  "SecurityHeaders": [],
  "CookiesObserved": [
    "__cf_bm=8EMUMs40ExBWo.WO9YuvsB2GcWoJztQMjPgaL0cwegA-1769823352-1.0.1.1-8_saa17RA0XkfhsmpXvHZ31VipSUykHjLBy4BFxv.Dhe_8LcTeyHYO9HPn06sXNwl_IF_KpFF0WYlO.CRT0E4XdpsdRTj1jzlzwne7wXcdE; path=/; expires=Sat, 31-Jan-26 02:05:52 GMT; domain=.www.benlcollins.com; HttpOnly; Secure; SameSite=None"
  ],
  "XhrApiHints": [],
  "SitemapCounts": {
    "total_urls": 3
  },
  "ChatWidgets": [],
  "ABTesting": [],
  "PrivacyConsent": [],
  "EmailMarketing": [],
  "WebFonts": [],
  "DynamicJs": [
    "jQuery (script Resource)",
    "Bootstrap (CSS Classes)",
    "Server Technology: WP Engine",
    "Web Server: cloudflare",
    "jQuery (CDN Detection)",
    "ES6+ JavaScript Features",
    "jQuery (Script Analysis)"
  ],
  "ResourceHosts": [
    "cdn.usefathom.com",
    "www.benlcollins.com",
    "js.sparkloop.app",
    "gmpg.org"
  ],
  "CssFrameworks": [],
  "BuildTools": [],
  "ServerTech": [
    "Generator: WP Rocket 3.20.3",
    "PHP (inferred from WordPress)"
  ],
  "DatabaseHints": [],
  "PageTitle": "Google Sheets and Apps Script Tutorials and Online Courses",
  "MetaDescription": "Beginner to advanced tutorials covering Google Sheets, Apps Script, data analysis, automation and APIs. Learn new skills today!",
  "ImageCount": 5,
  "ScriptCount": 21,
  "LinkCount": 29,
  "Errors": [
    "Reverse DNS failed: No such host is known."
  ],
  "UiFrameworks": [
    "D3.js",
    "AOS",
    "Bootstrap (Class Names)",
    "Vuetify (Class Names)"
  ]
}