We write about about automation, productivity, entrepreneurship, data Integration & spreadsheet tips.
Discover the best ETL tools designed to help startups understand their data.
Create pivot table with your database's data with Actiondesk
Find the best business intelligence tools for your business with this ultimate guide to BI tools for startup teams.
Actiondesk has raised $3.9m to build a spreadsheet natively connected to all of your business data sources. Learn more here
Use this sales report template to build more powerful HubSpot dashboards with HubSpot-Google Sheets integration.
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.
If you’re not sure where to start to make things better with your data, this article is for you.
Exporting data from MySQL to Google Sheets: the top 6 ways to get MySQL data to your spreadsheet in 2021.
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
Manipulate your data with a single Google Sheets QUERY function to easily analyze, transform and aggregate data.
Execute queries, retrieve and analyze your data, and create business reports in real-time with these top-performing SQL editors for startup teams.
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.
These are the top metrics that you need to track for increasing your revenue.
Integrating Actiondesk with Close to create dashboards, improve reporting, and strengthen analysis.
HubSpot integrations streamline the process of building a base of promoters, helping you retain customers while driving more conversions.
Compare the strengths and limitations of HubSpot and Salesforce to identify the best CRM solution for your business.
Use this step-by-step guide to bring your HubSpot dashboard data into Google Sheets by querying the HubSpot API with Google Apps Script.
ETL stands for extract, transform, and load. ETL helps businesses gather all of their data in the same place and make sense of it. Learn more about ETL here.
Learn about the strengths and limitations of HubSpot’s built-in reporting templates and how to achieve automated reporting.
Learn about HubSpot’s lifecycle stages and get tips on how to make the most of them to improve your HubSpot pipeline.
Compare the pros and cons of Pipedrive and HubSpot to find the perfect CRM platform for your business.
Top spreadsheet software in 2021. Infographics of the 26 most popular spreadsheets.
Learn how to export HubSpot data on contacts, deals, and emails with Actiondesk.
Find out how to elevate your HubSpot lead scoring to increase conversions and improve sales efficiency.
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.
Bad data cannot be avoided completely, but there are data cleaning steps you can take to maximize the value of your CRM data.
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.
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.
Looking for Airtable integrations? Zapier, Airtable importer and Actiondesk are the 3 best tools to move Airtable data to Google Sheets.
Learn how HubSpot lists can help you understand your HubSpot contacts (and their unique characteristics) better.
In this SQL for beginners article, you’ll learn how to access and retrieve your SQL data from a SQL database using SQL queries.
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.
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.
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.
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.
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.
At actiondesk, we believe spreadsheets are here to stay and will remain the central nervous system for most business teams. Here’s why.
This is a summary of all my best productivity routines & tips, and how I currently organize myself.
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.
Get a better understanding of your leads by building a report with all your contacts that's easy to filter and sort.
Actiondesk’s integration, reporting, and analytics capabilities are simplifying this education company’s relationship with data.
Use Actiondesk to calculate conversion from signup to deal signed across any HubSpot dimension you'd like.
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.
Actiondesk’s data integration and analysis capabilities are empowering this e-commerce company to do more with its data.
Get a better understanding of your companies by building a report 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.
Actiondesk’s integration, collaboration, and analysis capabilities are transforming this company’s relationship with data — and with its customers.
Moving Salesforce data to and from CSV (or a spreadsheet like Excel) has never been easier. Find the right tool for you.
A concrete todo list to prepare Y Combinator in person interview from Actiondesk's CEO (YC S19). With links to useful resources.
Want to export Zendesk Tickets, Users or any other data to Google Sheets? Here are some easy tools.
Create a view of all your open deals that's easy to filter and sort.
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.
Reverse ETL is the process of sending data from the data warehouse to your operational tools. Learn what reverse ETL is and how it can make your data actionable
Learn how to export SQL data to Excel and update the export automatically (MySQL, Microsoft SQL Server, PostgreSQL).
Simple guide to what a relational database is and how learning about it can help you become more efficient in the workplace.
Create a fully automated HubSpot sales rep dashboard to keep your objectives clear and your reps motivated.
For each month, calculate the # of contacts, deals, closed deals, lost deals, and lost and win rate.
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 best ways to easily export data from Salesforce into a spreadsheet.
Current spreadsheets, created 30 years ago, are broken. Actiondesk is a spreadsheet that lets you build internal applications using only your spreadsheet skills
Find out which tools is best for you based on integrations, data operations, event customization, user experience and pricing.
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
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.
Create a instant codeless integration between your database and Salesforce.
The VLOOKUP formula is super useful in Google sheets. This 1-minute video is just the perfect way to get how it works.
Understand how your sales pipeline behaves by calculating the number of deals per stage per month based on your HubSpot data.
Build reports that help you understand the performance of each of your sales reps.
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).
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.
Infography of the top 10 integration tools compared: Zapier vs 9 alternatives.
For Newbies to Seasoned Vets & From Roadmapping to Design
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
Data automation is simply the process of collecting, storing, handling, and processing your data without human intervention. Learn more about it here.
How to import your live data into Google Sheets from CRMS, social media, forums, SaaS applications and more.
Metabase is a popular Business Intelligence tool. Learn in this tutorial how to make the most of it
PostgreSQL exports have never been easier. I’ve outlined my favorite 4 tools.
The rise of “No Code” and how it turns anyone into a maker.