We write about about automation, productivity, entrepreneurship, data Integration & spreadsheet tips.
In this SQL for beginners article, you’ll learn how to access and retrieve your SQL data from a SQL database using SQL queries.
If you’re not sure where to start to make things better with your data, this article is for you.
Execute queries, retrieve and analyze your data, and create business reports in real-time with these top-performing SQL editors for startup teams.
Use this sales report template to build more powerful HubSpot dashboards with HubSpot-Google Sheets integration.
Learn how to automatically retrieve data from your SQL database and import it into Google Sheets with a script that you can copy and paste right into Google App
Exporting data from MySQL to Google Sheets: the top 6 ways to get MySQL data to your spreadsheet in 2021.
Learn, through an example, how to make a simple automated dashboard on Google Sheets for your metrics using SPARKLINE, VLOOKUP, Data Validation and Pivot Table.
Manipulate your data with a single Google Sheets QUERY function to easily analyze, transform and aggregate data.
Compare reporting, and data analysis tools: Power BI, Tableau, Qlik Sense, ThoughtSpot, Looker, Zoho Analytics, Toucan, Alteryx Platform, Sisense and Chartio.
We reviewed the use cases Airtable works well for. And explored Airtable alternatives for when it doesn’t fulfill your needs.
Learn how to use the Google Sheets array formula. You’ll be able to apply a formula to an entire column and add it automatically to future rows.
Top spreadsheet software in 2021. Infographics of the 26 most popular spreadsheets.
If you want to delete your pivot table and keep a backup of the resulting data, learn with this 1-minute video that explains it all for Google Sheets and Excel.
Looking for Airtable integrations? Zapier, Airtable importer and Actiondesk are the 3 best tools to move Airtable data to Google Sheets.
Improve HubSpot reporting and build beautiful, streamlined HubSpot dashboards with an effective HubSpot-Google Sheets integration solution.
Learn how an Intercom-HubSpot integration can help streamline your marketing and sales processes and improve productivity for your business.
Learn why some companies turn to HubSpot competitors and get insight into which CRM solution — whether HubSpot or an alternative — is best for your business.
Compare the pros and cons of Pipedrive and HubSpot to find the perfect CRM platform for your business.
Compare the pros and cons of the best data visualization tools on the market to find the perfect solution for maximizing the value of your HubSpot data.
Compare the strengths and limitations of HubSpot and Salesforce to identify the best CRM solution for your business.
Learn about HubSpot’s lifecycle stages and get tips on how to make the most of them to improve your HubSpot pipeline.
Find out how to elevate your HubSpot lead scoring to increase conversions and improve sales efficiency.
Use this step-by-step guide to bring your HubSpot dashboard data into Google Sheets by querying the HubSpot API with Google Apps Script.
Bad data cannot be avoided completely, but there are data cleaning steps you can take to maximize the value of your CRM data.
HubSpot integrations streamline the process of building a base of promoters, helping you retain customers while driving more conversions.
Learn about the strengths and limitations of HubSpot’s built-in reporting templates and how to achieve automated reporting.
Use this step-by-step guide to import data in CSV files into your HubSpot dashboard.
This guide to HubSpot reporting for sales leaders explores the benefits and limitations of HubSpot dashboards and how Actiondesk level-ups your reporting.
Learn how to export HubSpot data on contacts, deals, and emails with Actiondesk.
Learn how HubSpot lists can help you understand your HubSpot contacts (and their unique characteristics) better.
Better open and click-through rates result in more website traffic and sales. Conducting A/B tests in HubSpot can help you boost these rates.
Read this guide to performing a HubSpot export of HubSpot email data to learn how to take your HubSpot email marketing to the next level.
Course options for everyone from non-coders to experiences developers.
Stripe Dashboard For Real-Time SaaS Metrics: ProfitWell vs Baremetrics vs ChartMogul vs Woopra vs SaaSoptics vs Stripe Sigma
Discover how Actiondesk melds the best workflow automation tools with the ease of use of spreadsheets.
This is a summary of all my best productivity routines & tips, and how I currently organize myself.
At actiondesk, we believe spreadsheets are here to stay and will remain the central nervous system for most business teams. Here’s why.
Find which data visualization tool is best for your visuals based on what data you are trying to display.
Why use Scala? We listed the advantages of Scala we see at Actiondesk. See whether the benefits of Scala could help your startup too.
In true Silicon Valley startup style, Actiondesk’s team is all living and working together (6 adults and one 2 year old) in a house.
Use Actiondesk to calculate conversion from signup to deal signed across any HubSpot dimension you'd like.
Get a better understanding of your companies by building a report that's easy to filter and sort.
Get a better understanding of your leads by building a report with all your contacts that's easy to filter and sort.
Build a customized dashboard with the number of deals per deal stage per sales rep.
Get a better understanding of your HubSpot deals by building a report that's easy to filter and sort.
You'll find usual suspects alongside less known tools and a few gems, and also some tips on how to make the most of these tools
Code review is part of your engineering culture. What's a code review, what is expected from a reviewer, concrete advice on how to start, tips to make them work
A concrete todo list to prepare Y Combinator in person interview from Actiondesk's CEO (YC S19). With links to useful resources.
We've applied 4 times to Y Combinator before participating to YC S19. Here's a few things we've learnt to write a good Y Combinator application.
The VLOOKUP formula is super useful in Google sheets. This 1-minute video is just the perfect way to get how it works.
Learn how to sort your data in a pivot table, ordering it in ascending or descending order in Google Sheets, or sort from smallest to largest in Excel.
Learn how to export SQL data to Excel and update the export automatically (MySQL, Microsoft SQL Server, PostgreSQL).
Current spreadsheets, created 30 years ago, are broken. Actiondesk is a spreadsheet that lets you build internal applications using only your spreadsheet skills
Create a instant codeless integration between your database and Salesforce.
Want to export Zendesk Tickets, Users or any other data to Google Sheets? Here are some easy tools.
PostgreSQL exports have never been easier. I’ve outlined my favorite 4 tools.
The best ways to easily export data from Salesforce into a spreadsheet.
APIs for Dummies? More like “API for Any Normal Person” because this is complex stuff, but it doesn’t have to be. Let’s break it down.
How to import your live data into Google Sheets from CRMS, social media, forums, SaaS applications and more.
For Newbies to Seasoned Vets & From Roadmapping to Design
Moving Salesforce data to and from CSV (or a spreadsheet like Excel) has never been easier. Find the right tool for you.
Simple guide to what a relational database is and how learning about it can help you become more efficient in the workplace.
Find out which tools is best for you based on integrations, data operations, event customization, user experience and pricing.
6 weeks ago, we launched the public beta of our product Actiondesk on Product Hunt and got great traction there (here’s the story of our Product Hunt launch).
A bit more than 1 month ago, we launched our public beta on Product Hunt and we’ve been pretty happy with the results.
The rise of “No Code” and how it turns anyone into a maker.
Infography of the top 10 integration tools compared: Zapier vs 9 alternatives.
For each month, calculate the # of contacts, deals, closed deals, lost deals, and lost and win rate.
Build reports that help you understand the performance of each of your sales reps.
Understand how your sales pipeline behaves by calculating the number of deals per stage per month based on your HubSpot data.
Create a fully automated HubSpot sales rep dashboard to keep your objectives clear and your reps motivated.
Create a view of all your open deals that's easy to filter and sort.
Metabase is a popular Business Intelligence tool. Learn in this tutorial how to make the most of it