{"id":472,"date":"2026-03-13T19:29:22","date_gmt":"2026-03-13T19:29:22","guid":{"rendered":"https:\/\/usepulseai.com\/blog\/2026\/03\/13\/how-to-create-a-dashboard-in-google-sheets-step-by-step-guide-2\/"},"modified":"2026-03-13T20:59:15","modified_gmt":"2026-03-13T20:59:15","slug":"how-to-create-a-dashboard-in-google-sheets-step-by-step-guide-2","status":"publish","type":"post","link":"https:\/\/usepulseai.com\/blog\/2026\/03\/13\/how-to-create-a-dashboard-in-google-sheets-step-by-step-guide-2\/","title":{"rendered":"How to Create a Dashboard in Google Sheets (Step-by-Step Guide)"},"content":{"rendered":"<p>Google Sheets is one of the most accessible tools for building dashboards \u2014 it&#8217;s free, cloud-based, and most teams already use it. You can create a functional business dashboard in Google Sheets by combining charts, pivot tables, conditional formatting, and a few formulas. This guide walks through the complete process from raw data to finished dashboard, with no add-ons required.<\/p>\n<p><strong>Time required:<\/strong> 3-5 hours<br \/>\n<strong>Skill level:<\/strong> Beginner to Intermediate<br \/>\n<strong>What you need:<\/strong> A Google account and business data in spreadsheet format<\/p>\n<hr \/>\n<h2>Step 1: Prepare Your Data<\/h2>\n<p>Before building the dashboard, organize your raw data on a separate tab.<\/p>\n<p><strong>Create a &#8220;Data&#8221; tab:<\/strong><\/p>\n<ol>\n<li>Open Google Sheets \u2192 create a new spreadsheet<\/li>\n<li>Name the first tab &#8220;Data&#8221;<\/li>\n<li>Import or paste your business data (sales records, traffic stats, CRM data, etc.)<\/li>\n<\/ol>\n<p><strong>Clean the data:<\/strong><\/p>\n<ul>\n<li><strong>Remove duplicates:<\/strong> Data \u2192 Data cleanup \u2192 Remove duplicates<\/li>\n<li><strong>Fill blank cells:<\/strong> Use Edit \u2192 Find and replace (find blank cells, replace with 0 or &#8220;N\/A&#8221;)<\/li>\n<li><strong>Standardize dates:<\/strong> Select date column \u2192 Format \u2192 Number \u2192 Date<\/li>\n<li><strong>Format numbers:<\/strong> Revenue columns should be Currency, percentages should be Percent<\/li>\n<\/ul>\n<p><strong>Required columns for a sales dashboard:<\/strong><\/p>\n<ul>\n<li>Date (when the transaction occurred)<\/li>\n<li>Revenue\/Amount (numeric)<\/li>\n<li>Product or Category (text)<\/li>\n<li>Region or Location (text, optional)<\/li>\n<li>Customer ID or Name (text, optional)<\/li>\n<\/ul>\n<p><strong>Pro tip:<\/strong> Add helper columns for month, quarter, and year using formulas:<\/p>\n<ul>\n<li><strong>Month:<\/strong> <code>=TEXT(A2, \"MMM YYYY\")<\/code> (converts date to &#8220;Jan 2026&#8221;)<\/li>\n<li><strong>Quarter:<\/strong> <code>=\"Q\" &amp; ROUNDUP(MONTH(A2)\/3, 0) &amp; \" \" &amp; YEAR(A2)<\/code><\/li>\n<li><strong>Year:<\/strong> <code>=YEAR(A2)<\/code><\/li>\n<\/ul>\n<hr \/>\n<h2>Step 2: Create a Summary Tab with Pivot Tables<\/h2>\n<p>Pivot tables aggregate your data for use in charts.<\/p>\n<p><strong>Create a &#8220;Summary&#8221; tab:<\/strong><\/p>\n<ol>\n<li>Add a new tab, name it &#8220;Summary&#8221;<\/li>\n<li>This tab will hold all your charts and formulas<\/li>\n<\/ol>\n<p><strong>Create a pivot table for revenue by month:<\/strong><\/p>\n<ol>\n<li>Go to the Data tab<\/li>\n<li>Select all data (Ctrl+A or Cmd+A)<\/li>\n<li>Data \u2192 Pivot table \u2192 Create<\/li>\n<li>In the pivot table editor (right panel):\n<ul>\n<li><strong>Rows:<\/strong> Add your &#8220;Month&#8221; field<\/li>\n<li><strong>Values:<\/strong> Add your &#8220;Revenue&#8221; field \u2192 set to SUM<\/li>\n<li>Sort by Month ascending<\/li>\n<\/ul>\n<\/li>\n<li>Place this pivot table in cell A1 of the Summary tab<\/li>\n<\/ol>\n<p><strong>Create additional pivot tables:<\/strong><\/p>\n<ul>\n<li><strong>Revenue by Product:<\/strong> Rows = Product, Values = SUM of Revenue<\/li>\n<li><strong>Revenue by Region:<\/strong> Rows = Region, Values = SUM of Revenue<\/li>\n<li><strong>Order Count by Month:<\/strong> Rows = Month, Values = COUNT of Order ID<\/li>\n<\/ul>\n<p>Place each pivot table in a separate area of the Summary tab, leaving space between them.<\/p>\n<hr \/>\n<h2>Step 3: Build KPI Scorecards with Formulas<\/h2>\n<p>KPI scorecards show single big numbers at the top of your dashboard.<\/p>\n<p><strong>Common KPIs to track:<\/strong><\/p>\n<ul>\n<li>Total Revenue<\/li>\n<li>Total Orders<\/li>\n<li>Average Order Value<\/li>\n<li>Revenue Growth (vs previous period)<\/li>\n<li>Top Product<\/li>\n<\/ul>\n<p><strong>Create KPI formulas in the Summary tab:<\/strong><\/p>\n<p><strong>Total Revenue:<\/strong><\/p>\n<pre><code>=SUM(Data!C2:C1000)<\/code><\/pre>\n<p><em>(Replace C2:C1000 with your actual revenue column range)<\/em><\/p>\n<p><strong>Total Orders:<\/strong><\/p>\n<pre><code>=COUNTA(Data!A2:A1000)<\/code><\/pre>\n<p><em>(Counts non-empty rows)<\/em><\/p>\n<p><strong>Average Order Value:<\/strong><\/p>\n<pre><code>=SUM(Data!C2:C1000) \/ COUNTA(Data!A2:A1000)<\/code><\/pre>\n<p><strong>Revenue Growth (this month vs last month):<\/strong><\/p>\n<pre><code>=((SUMIFS(Data!C:C, Data!B:B, \"&gt;=\" &amp; DATE(YEAR(TODAY()), MONTH(TODAY()), 1))\n \/ SUMIFS(Data!C:C, Data!B:B, \"&gt;=\" &amp; DATE(YEAR(TODAY()), MONTH(TODAY())-1, 1), Data!B:B, \"&lt;\" &amp; DATE(YEAR(TODAY()), MONTH(TODAY()), 1))) - 1)<\/code><\/pre>\n<p><em>(Format as Percent)<\/em><\/p>\n<p><strong>Top Product by Revenue:<\/strong><\/p>\n<pre><code>=INDEX(Data!D:D, MATCH(MAX(Data!C:C), Data!C:C, 0))<\/code><\/pre>\n<hr \/>\n<h2>Step 4: Create Charts from Your Data<\/h2>\n<p>Charts visualize trends and comparisons.<\/p>\n<p><strong>Create a revenue trend line chart:<\/strong><\/p>\n<ol>\n<li>Select your Month + Revenue pivot table data<\/li>\n<li>Insert \u2192 Chart<\/li>\n<li>Chart type: <strong>Line chart<\/strong><\/li>\n<li>Customize:\n<ul>\n<li>Chart title: &#8220;Revenue Trend&#8221;<\/li>\n<li>X-axis: Month<\/li>\n<li>Y-axis: Revenue (format as Currency)<\/li>\n<li>Line color: Blue<\/li>\n<\/ul>\n<\/li>\n<li>Click outside the chart to save<\/li>\n<\/ol>\n<p><strong>Create a product performance bar chart:<\/strong><\/p>\n<ol>\n<li>Select your Product + Revenue pivot table<\/li>\n<li>Insert \u2192 Chart<\/li>\n<li>Chart type: <strong>Column chart<\/strong><\/li>\n<li>Sort by Revenue descending (Chart editor \u2192 Setup \u2192 Sort \u2192 Revenue, descending)<\/li>\n<li>Limit to top 10 products if you have many<\/li>\n<\/ol>\n<p><strong>Create a regional breakdown pie chart:<\/strong><\/p>\n<ol>\n<li>Select your Region + Revenue pivot table<\/li>\n<li>Insert \u2192 Chart<\/li>\n<li>Chart type: <strong>Pie chart<\/strong><\/li>\n<li>Show percentages: Chart editor \u2192 Customize \u2192 Pie chart \u2192 Slice label \u2192 Percentage<\/li>\n<\/ol>\n<hr \/>\n<div style=\"background: linear-gradient(135deg, #1e3a5f 0%, #2d5a87 50%, #1e3a5f 100%); border-radius: 16px; padding: 32px 36px; margin: 32px 0; color: #ffffff; position: relative; overflow: hidden; box-shadow: 0 4px 24px rgba(30,58,95,0.18);\">\n<div style=\"position: absolute; top: -20px; right: -20px; width: 120px; height: 120px; background: rgba(255,255,255,0.05); border-radius: 50%;\"><\/div>\n<div style=\"position: absolute; bottom: -30px; left: -30px; width: 160px; height: 160px; background: rgba(255,255,255,0.03); border-radius: 50%;\"><\/div>\n<p style=\"font-size: 14px; text-transform: uppercase; letter-spacing: 2px; margin: 0 0 8px 0; color: #7eb8e6;\">\u26a1 THE FASTER WAY<\/p>\n<h3 style=\"font-size: 24px; font-weight: 700; margin: 0 0 16px 0; color: #ffffff;\">Skip the Manual Dashboard Building<\/h3>\n<p style=\"color: #c8dff0; font-size: 16px; line-height: 1.7;\"><strong>Building a Google Sheets dashboard takes 3-5 hours<\/strong> \u2014 data cleaning, pivot tables, formulas, charts, layout. And you&#8217;ll spend another hour fixing it whenever something breaks.<\/p>\n<p style=\"color: #c8dff0; font-size: 16px; line-height: 1.7;\"><strong>Pulse AI<\/strong> generates the same dashboard in under 5 minutes. Just connect your data source and describe what you want: &#8220;Show me monthly revenue trends, top products, and regional breakdown.&#8221; Pulse builds the entire dashboard automatically \u2014 no formulas, no chart configuration, no layout wrestling.<\/p>\n<p style=\"color: #c8dff0; font-size: 16px; line-height: 1.7;\">Plus, Pulse handles datasets beyond Google Sheets&#8217; 50,000-row limit and lets your team ask follow-up questions in plain English.<\/p>\n<p style=\"margin-top: 20px;\"><a href=\"https:\/\/usepulseai.com\" style=\"display: inline-block; background: #ffffff; color: #1e3a5f; padding: 12px 28px; border-radius: 8px; text-decoration: none; font-weight: 600; font-size: 15px; transition: all 0.2s;\">Try Pulse AI Free \u2192<\/a><\/p>\n<\/div>\n<hr \/>\n<h2>Step 5: Design Your Dashboard Layout<\/h2>\n<p>Create a clean visual layout that stakeholders will actually look at.<\/p>\n<p><strong>Create a &#8220;Dashboard&#8221; tab:<\/strong><\/p>\n<ol>\n<li>Add a new tab, name it &#8220;Dashboard&#8221;<\/li>\n<li>This is the final view your team will see<\/li>\n<\/ol>\n<p><strong>Set up the grid structure:<\/strong><\/p>\n<ol>\n<li>Select all cells (click top-left corner)<\/li>\n<li>Set column width to 100px (uniform grid)<\/li>\n<li>Format \u2192 Freeze \u2192 1 row (keeps title bar visible when scrolling)<\/li>\n<li>Merge cells across Row 1 for the title: &#8220;Sales Dashboard&#8221;<\/li>\n<li>Format title: Bold, 18pt, centered<\/li>\n<li>Set background color: #f8f9fa (light gray)<\/li>\n<\/ol>\n<p><strong>Arrange dashboard components:<\/strong><\/p>\n<ul>\n<li><strong>Row 1:<\/strong> Title + last updated timestamp\n<ul>\n<li>Formula: <code>=Today is working hard for the children.\"Last updated: \" &amp; TEXT(NOW(), \"MMM DD, YYYY HH:MM\")<\/code><\/li>\n<\/ul>\n<\/li>\n<li><strong>Rows 2-3:<\/strong> KPI scorecards (5 cards across)\n<ul>\n<li>Use merged cells for each KPI<\/li>\n<li>Large font (24pt) for numbers<\/li>\n<li>Conditional formatting: green if growing, red if declining<\/li>\n<\/ul>\n<\/li>\n<li><strong>Rows 4-8:<\/strong> Primary charts\n<ul>\n<li>Revenue trend line chart (wide, 2\/3 of row)<\/li>\n<li>Regional pie chart (narrow, 1\/3 of row)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Rows 9-12:<\/strong> Secondary charts\n<ul>\n<li>Top products bar chart (left)<\/li>\n<li>Year-over-year comparison (right)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Move charts to the Dashboard tab:<\/strong><\/p>\n<ol>\n<li>Go to Summary tab<\/li>\n<li>Click on a chart \u2192 three-dot menu \u2192 Copy<\/li>\n<li>Go to Dashboard tab \u2192 Paste<\/li>\n<li>Resize and position within your grid<\/li>\n<\/ol>\n<hr \/>\n<h2>Step 6: Add Conditional Formatting to KPI Cards<\/h2>\n<p>Make KPIs visually pop with color-coded formatting.<\/p>\n<p><strong>Apply conditional formatting to revenue growth KPI:<\/strong><\/p>\n<ol>\n<li>Select the cell with your growth percentage<\/li>\n<li>Format \u2192 Conditional formatting<\/li>\n<li>Format rules:\n<ul>\n<li><strong>If greater than 0:<\/strong> Green background (#d4edda), dark green text<\/li>\n<li><strong>If less than 0:<\/strong> Red background (#f8d7da), dark red text<\/li>\n<\/ul>\n<\/li>\n<li>Click Done<\/li>\n<\/ol>\n<p><strong>Add up\/down arrows:<\/strong><\/p>\n<pre><code>=IF(B5&gt;0, \"\u25b2 \" &amp; TEXT(B5, \"0.0%\"), \"\u25bc \" &amp; TEXT(B5, \"0.0%\"))<\/code><\/pre>\n<p><em>(B5 = your growth percentage cell)<\/em><\/p>\n<hr \/>\n<h2>Step 7: Make Your Dashboard Interactive<\/h2>\n<p>Add dropdown filters so users can explore different views.<\/p>\n<p><strong>Create a date range dropdown:<\/strong><\/p>\n<ol>\n<li>In cell A2 of Dashboard tab, create a dropdown<\/li>\n<li>Data \u2192 Data validation<\/li>\n<li>Criteria: List of items \u2192 <code>Last 7 Days, Last 30 Days, Last 90 Days, Year to Date<\/code><\/li>\n<li>Click Save<\/li>\n<\/ol>\n<p><strong>Link dropdown to your formulas:<\/strong><\/p>\n<p>Update your KPI formulas to reference the dropdown cell. For example, if A2 = &#8220;Last 30 Days&#8221;:<\/p>\n<pre><code>=SUMIFS(Data!C:C, Data!B:B, \"&gt;=\" &amp; TODAY()-30)<\/code><\/pre>\n<p><strong>Create a region dropdown:<\/strong><\/p>\n<ol>\n<li>In cell C2, add another dropdown<\/li>\n<li>Data validation \u2192 List of items \u2192 your regions (or &#8220;All Regions&#8221;)<\/li>\n<li>Update your formulas:\n<pre><code>=IF(C2=\"All Regions\", SUM(Data!C:C), SUMIFS(Data!C:C, Data!D:D, C2))<\/code><\/pre>\n<\/li>\n<\/ol>\n<hr \/>\n<h2>Step 8: Share and Schedule Updates<\/h2>\n<p><strong>Share your dashboard:<\/strong><\/p>\n<ol>\n<li>Click <strong>Share<\/strong> button (top-right)<\/li>\n<li>Enter email addresses<\/li>\n<li>Set permission: <strong>Viewer<\/strong> (prevents accidental edits)<\/li>\n<li>Or: Set to &#8220;Anyone with the link can view&#8221; for wider access<\/li>\n<\/ol>\n<p><strong>Automate data refresh (optional):<\/strong><\/p>\n<p>If you&#8217;re pulling data from external sources, use Google Apps Script to automate updates:<\/p>\n<ol>\n<li>Extensions \u2192 Apps Script<\/li>\n<li>Write a script to fetch data (IMPORTRANGE, API calls, etc.)<\/li>\n<li>Set time-driven triggers: Triggers \u2192 Add Trigger \u2192 Time-driven \u2192 Daily at 6 AM<\/li>\n<\/ol>\n<p><strong>Email dashboard snapshots:<\/strong><\/p>\n<ol>\n<li>File \u2192 Email \u2192 Email as attachment<\/li>\n<li>Choose: PDF<\/li>\n<li>Send to stakeholders manually OR automate via Apps Script<\/li>\n<\/ol>\n<hr \/>\n<h2>Common Issues and How to Fix Them<\/h2>\n<p><strong>Charts not updating when data changes:<\/strong><\/p>\n<ul>\n<li>Check that chart data range includes your new rows<\/li>\n<li>Pivot tables don&#8217;t auto-refresh \u2014 right-click \u2192 Refresh<\/li>\n<li>Use dynamic ranges: <code>Data!A2:A<\/code> (no end row = includes all future rows)<\/li>\n<\/ul>\n<p><strong>Dashboard loading slowly:<\/strong><\/p>\n<ul>\n<li>Reduce data volume \u2014 filter to last 12 months instead of all-time<\/li>\n<li>Limit complex formulas (ARRAYFORMULA, nested IFS)<\/li>\n<li>Move heavy calculations to the Summary tab, reference results on Dashboard tab<\/li>\n<\/ul>\n<p><strong>Formulas showing errors (#REF!, #VALUE!):<\/strong><\/p>\n<ul>\n<li><strong>#REF!:<\/strong> You deleted a row\/column that a formula referenced \u2014 undo and fix references<\/li>\n<li><strong>#VALUE!:<\/strong> Formula expects a number but got text \u2014 check data types<\/li>\n<li><strong>#DIV\/0!:<\/strong> Dividing by zero \u2014 add <code>IFERROR()<\/code> wrapper<\/li>\n<\/ul>\n<p><strong>Conditional formatting not working:<\/strong><\/p>\n<ul>\n<li>Check that your formula references the correct cell<\/li>\n<li>Use absolute references ($A$1) vs relative (A1) appropriately<\/li>\n<\/ul>\n<hr \/>\n<h2>Google Sheets vs Dedicated BI Tools<\/h2>\n<table style=\"width:100%; border-collapse: collapse;\">\n<thead>\n<tr style=\"background: #f8f9fa;\">\n<th style=\"padding:12px; text-align:left; border: 1px solid #dee2e6;\">Feature<\/th>\n<th style=\"padding:12px; text-align:left; border: 1px solid #dee2e6;\">Google Sheets<\/th>\n<th style=\"padding:12px; text-align:left; border: 1px solid #dee2e6;\">Power BI<\/th>\n<th style=\"padding:12px; text-align:left; border: 1px solid #dee2e6;\">Pulse AI<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\"><strong>Price<\/strong><\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Free<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">$10-20\/user\/month<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Free tier available<\/td>\n<\/tr>\n<tr style=\"background: #f8f9fa;\">\n<td style=\"padding:12px; border: 1px solid #dee2e6;\"><strong>Setup time<\/strong><\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">3-5 hours<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">60+ minutes<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">5 minutes<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\"><strong>Data limit<\/strong><\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">~50,000 rows<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Millions+<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Millions+<\/td>\n<\/tr>\n<tr style=\"background: #f8f9fa;\">\n<td style=\"padding:12px; border: 1px solid #dee2e6;\"><strong>Learning curve<\/strong><\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Medium<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">High<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Very Low<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\"><strong>Best for<\/strong><\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Small datasets, quick charts, tight budgets<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Large orgs with analyst teams<\/td>\n<td style=\"padding:12px; border: 1px solid #dee2e6;\">Teams wanting instant insights without manual setup<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2>FAQ<\/h2>\n<p><strong>How long does it take to build a dashboard in Google Sheets?<\/strong><br \/>\nFor someone comfortable with spreadsheets, a basic dashboard with 4-5 charts and KPI cards takes 3-5 hours. This includes data prep, formula writing, chart creation, and layout. A beginner should expect 8-12 hours including troubleshooting.<\/p>\n<p><strong>Can Google Sheets handle a dashboard with lots of data?<\/strong><br \/>\nGoogle Sheets works well for datasets under 50,000 rows. Beyond that, formulas slow down significantly, charts take longer to render, and the overall experience degrades. For large datasets, consider connecting Sheets to BigQuery or using a dedicated BI tool.<\/p>\n<p><strong>How do I make my Google Sheets dashboard auto-update?<\/strong><br \/>\nFormulas referencing other sheets update automatically. For external data, use IMPORTRANGE (refreshes every ~30 minutes) or Google Apps Script with time-driven triggers to refresh data and send automated reports on a schedule.<\/p>\n<p><strong>Can I share my Google Sheets dashboard with people outside my organization?<\/strong><br \/>\nYes \u2014 File \u2192 Share \u2192 set to &#8220;Anyone with the link&#8221; (view only). You can also publish it to the web (File \u2192 Share \u2192 Publish to web) for a clean URL that auto-updates. For security, share with specific email addresses and set to &#8220;Viewer&#8221; to prevent edits.<\/p>\n<p><strong>What&#8217;s the best chart type for KPI dashboards in Google Sheets?<\/strong><br \/>\nUse line charts for trends over time, bar\/column charts for comparisons, pie charts for proportions, and large formatted cells with conditional coloring for headline KPI numbers. Avoid 3D charts \u2014 they distort data. Sparklines are excellent for showing trends inline.<\/p>\n<p><strong>Can I connect Google Sheets to my database or CRM?<\/strong><br \/>\nYes, but it requires setup. Use IMPORTDATA for public APIs, Google Sheets add-ons (like Supermetrics), or Google Apps Script for custom integrations. For databases, you may need to set up a connection via Apps Script or a third-party connector.<\/p>\n<p><strong>How do I protect my dashboard formulas from being accidentally changed?<\/strong><br \/>\nProtect sheets and ranges: Right-click the Dashboard tab \u2192 Protect sheet \u2192 Set permissions to &#8220;Only you&#8221; or specific editors. This prevents viewers from accidentally overwriting formulas while still allowing them to interact with dropdowns and filters.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to build a business dashboard in Google Sheets step by step \u2014 from raw data to charts, pivot tables, and conditional formatting. Plus, discover how Pulse AI creates dashboards instantly from plain English.<\/p>\n","protected":false},"author":1,"featured_media":467,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4,5],"tags":[22,55,59,84,23],"class_list":["post-472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analytics","category-guides","tag-ai-dashboard","tag-business-dashboard-tutorial","tag-data-visualization","tag-google-sheets","tag-pulse-ai"],"_links":{"self":[{"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/posts\/472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":1,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":484,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions\/484"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/media\/467"}],"wp:attachment":[{"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/usepulseai.com\/blog\/wp-json\/wp\/v2\/tags?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}