profile

Google Sheets Tips

by Ben Collins

Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.

PostsLinks
Featured Post

Google Sheets Tips Issue 300!! 🎉

Hi Reader, Welcome to this anniversary edition of the Google Sheets Tips newsletter, your Monday morning espresso, in spreadsheet form. This is the 300th edition of this weekly newsletter! 🎉 I've been sending it out for six years. The first issue — about keyboard shortcuts — was sent on 30 April 2018 to 2,357 of you. (Huge shout-out to anyone who's still with me!) In honor of this milestone, I want to look back at the six-year journey: The newsletter began life as the "Monday Tip" newsletter,...

6 days ago • 2 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #299, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: SHORTFORM Raising the Bar on Book Summaries With Shortform, you get deep insights that go beyond the typical 1-pager, with chapter breakdowns, well-researched commentary and analysis, connections to other books and counter-arguments, and even interactive exercises. Instead of spending days on a...

13 days ago • 3 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #298, your Monday morning espresso, in spreadsheet form! I hope you are doing well on this fabulous Monday morning. As an adult, it's rare to experience something completely new in day-to-day life. Days follow a familiar pattern, even if the specifics are different. Last week, however, the New York region was hit by a rare earthquake (thankfully, not too serious). I happened to be in Legoland New York with my family, in the gift shop,...

20 days ago • 3 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #297, your Monday morning espresso, in spreadsheet form! Coming to your inbox on a Tuesday this week because many folks have a long weekend for Easter. In the mountains near where I live, the Virginia Bluebells are in full bloom and the trails are beautiful! A big thank you to this week's sponsors who help keep this newsletter free to read: BUDGETSHEET Import Bank Transactions Automatically The easiest way to import bank transactions...

26 days ago • 1 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #296, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: TAPLIO Grow your LinkedIn audience with the power of AI Taplio helps you grow and leverage your personal brand on LinkedIn to build an audience and attract more leads and opportunities. Create high-performing LinkedIn posts, engage with your target audience, find leads and measure all your results....

about 1 month ago • 2 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #295, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: SHEET CHAT Your Powerful AI Google Sheets Copilot Sheet Chat is an AI-powered Copilot that helps you work efficiently in Google Sheets and Google Docs. Use it for free with your OpenAI API key and hosting, and create your own custom agent based on your specific requirements. Try it for free!...

about 1 month ago • 3 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #294, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: SAPIENGRAPH Add LinkedIn and Crunchbase data via custom formulas to GSheets Sapiengraph makes it easy to fill your Google Sheets with fresh, accurate data from LinkedIn and Crunchbase. Using our intuitive custom formulas: VCs can track the employee count of portfolio companies with...

about 2 months ago • 2 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #293, your Monday morning espresso, in spreadsheet form! This week, I'm discussing spreadsheets live on YouTube on the Totally Unscripted show. The episode airs this Wednesday (6th March) at 3 pm Eastern time. Tune in here and ask your questions! A big thank you to this week's sponsors who help keep this newsletter free to read: BUDGETSHEET Save time this tax season Why not automate the most tedious part of doing your taxes this tax...

about 2 months ago • 2 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #292, your Monday morning espresso, in spreadsheet form! Quick question before this week's email: If you use Apps Script, what do you use it for? Follow up, what pain points do you have? (Feel free to just hit reply to this email.) A big thank you to this week's sponsors who help keep this newsletter free to read: OCTOBOARD GOOGLE SHEETS DATA EXPORT Send all your PPC data to Google Sheets for free Tired of paying hundreds of dollars for...

2 months ago • 2 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #291, your Monday morning espresso, in spreadsheet form! Coming to you on a Tuesday, because yesterday was Presidents' Day here in the US. Oh, the quiet irony of making Monday the subject of a newsletter I send on Mondays... only for it to fall on a week that I send the newsletter on a Tuesday instead. A big thank you to this week's sponsors who help keep this newsletter free to read: UNITO Automatically Collect Your Marketing Data in...

2 months ago • 2 min read
Share this page