Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to build an automated accounting dashboard that tracks real-time business data in this 33-minute tutorial. Follow along as the instructor demonstrates how to create a comprehensive system using Make.com automation platform, PandaDoc for document management, Google Sheets for data storage, and Looker Studio (formerly Data Studio) for visualization. Master the process of setting up PandaDoc triggers to automatically capture contract and payment data, use iterators to process multiple data points, and seamlessly transfer information to Google Sheets for organization. Discover how to model your financial data effectively in Looker Studio and create professional graphs and visualizations that provide instant insights into your business performance. The tutorial covers essential automation concepts including document watching, payment filtering, and real-time data synchronization, making it valuable for business owners, entrepreneurs, and automation enthusiasts looking to streamline their financial tracking and reporting processes.
Syllabus
0:00 Intro
2:53 Software involved
6:05 PandaDoc starting trigger
8:20 Iterator
9:55 Dump PandaDoc data into Google Sheets
20:57 Modelling data in DataStudio/LookerStudio
24:19 Creating graphs in LookerStudio
29:49 PandaDoc watch for documents
31:38 PandaDoc filtering document by paid
32:40 Conclusion
Taught by
Jono Catliff