{"id":256119,"date":"2025-07-24T12:55:23","date_gmt":"2025-07-24T10:55:23","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=256119"},"modified":"2026-03-06T14:52:55","modified_gmt":"2026-03-06T13:52:55","slug":"limpeza-de-dados","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/how-to-solve-with-sheetgo\/data-cleaning\/","title":{"rendered":"Limpeza e normaliza\u00e7\u00e3o autom\u00e1ticas de dados: Simplifique o Google Sheets com o Sheetgo AI"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ _builder_version=”4.27.4″ _module_preset=”default” da_disable_devices=”off|off|off” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” min_height=”7039.6px” custom_margin=”|auto|19px|auto||” custom_padding=”||96px|||” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

Spreadsheets are vital to how nearly every team operates, powering everything from sales tracking and hiring pipelines to expense reports and marketing dashboards. <\/sup><\/span>However, anyone who works with spreadsheet data quickly learns a universal truth: bad data breaks everything, <\/sup><\/span> making automatic data cleaning<\/b> and normalisation essential for efficiency.<\/span><\/p>\n

You might find names written in <\/span>ALL CAPS<\/b> in one column, while another has <\/span>extra spaces<\/b> that stop things from matching up correctly. <\/span>Dates are especially tricky<\/b>; they come in all sorts of formats from different countries. What should be a quick check often turns into a long, tedious cleanup job. You end up spending hours manually removing spaces, fixing capitalization, and changing how values look, just to make your data usable.\u00a0<\/span><\/p>\n

This problem gets even bigger when data comes from <\/span>different sources<\/b>. Inputs from web forms, exported CSV files, third-party apps, or even manual entries from various team members each bring their own quirks, including inconsistent formatting.<\/span><\/p>\n

The Pain of Messy Data (and Why Automatic Data Cleaning<\/b> is Essential)<\/h2>\n

Dirty Data doesn\u2019t announce itself\u2013but its impact is everywhere.\u00a0<\/span><\/span><\/p>\n

<\/span><\/p>\n

A spreadsheet filled with inconsistent date formats, misplaced capitalisation, duplicate values, or extra spaces might seem harmless at first. <\/sup><\/span>But zoom out, you\u2019ll find it\u2019s often the root cause behind broken reports, failed integrations, and poor decision-making. <\/sup><\/span> This highlights the critical need for automatic data cleaning<\/b>.<\/span><\/p>\n

Examples of Dirty\/Messy Data:\u00a0<\/span><\/p>\n

    \n
  • Dates that don\u2019t align (<\/span>01\/07\/25<\/span>, <\/span>July 1st, 2025<\/span>, <\/span>2025-07-01<\/span>)<\/span><\/li>\n
  • Inconsistent name formatting (<\/span>jOHN dOE<\/span>, <\/span>JOHN DOE<\/span>, <\/span>John Doe<\/span>)<\/span><\/li>\n
  • Varying currency and number formats (<\/span>\u20b91000<\/span>, <\/span>1000 INR<\/span>, <\/span>Rs. 1,000.00<\/span>)<\/span><\/li>\n
  • Extra spaces that break filters, lookups, or pivot tables<\/span><\/li>\n
  • Tags and categories with inconsistent spelling or capitalization<\/span><\/li>\n<\/ul>\n

    This is where Sheetgo\u2019s AI Data Processor comes in. It understands your intent through simple natural language prompts and cleans up messy, inconsistent data columns in seconds\u2013across any Google Sheet. Sheetgo\u2019s AI Data Processor is a game-changer for anyone tired of dealing with inconsistent, messy spreadsheets, offering true automatic data cleaning<\/strong>.<\/p>\n

    Sheetgo\u2019s AI Data Processor<\/b><\/h2>\n

    Sheetgo\u2019s AI Data Processor is a game-changer for anyone tired of dealing with inconsistent, messy spreadsheets. Built directly into the Sheetgo platform, this processor uses <\/span>natural language prompts<\/b> to understand what you want cleaned, fixed, or formatted\u2013then applies those changes automatically across your dataset.\u00a0<\/span><\/p>\n

    No formulas, no scripts, just simple instructions like:\u00a0<\/span><\/p>\n

    \n

    \u00a0Read the text in the <\/span>Customer Feedback column<\/b>. Create a new column called <\/span>Sentiment<\/b>. Based on the tone and content of the feedback, classify each entry as <\/span>Positive<\/b>, <\/span>Negative<\/b>, or <\/span>Neutral<\/b>.\u00a0<\/span><\/p>\n<\/blockquote>\n

    With support for multiple transformations in a single prompt, you can instantly fix:\u00a0<\/span><\/p>\n

      \n
    • Inconsistent name formatting\u00a0<\/span><\/li>\n
    • Mixed date and number formats\u00a0<\/span><\/li>\n
    • Currency and phone number inconsistencies<\/span><\/li>\n
    • Spacing, punctuation, and typos<\/span><\/li>\n<\/ul>\n

      Whether you\u2019re working with leads, employee data, campaign results, or invoices\u2013the AI Data Processor adapts to your columns, your structure, and your requirements. It plugs into your Sheetgo workflow, so you can schedule cleanups to run daily, weekly, or anytime new data is added.\u00a0<\/span><\/p>\n

      From one-time corrections to full-scale automations, the AI Data Processor scales with your needs\u2014no technical background required.<\/span><\/p>\n

       <\/p>\n

      Sign up for Sheetgo<\/b>\u00a0<\/span><\/h2>\n

      First, you\u2019ll need a Sheetgo account. It\u2019s free to get started and the process takes less than a minute.\u00a0<\/span><\/p>\n

        \n
      1. Go to the Sheetgo website and sign up using your existing Google account.\u00a0<\/span><\/li>\n
      2. Once you\u2019re signed in, you\u2019ll land on the main site. Once you\u2019re in, click the + Create workflow button and select Start from scratch to follow along with this guide.<\/span><\/li>\n<\/ol>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/3-scaled.webp” title_text=”3″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

        That\u2019s it. You\u2019re now ready to connect your data and tell Sheetgo what you want to achieve with the <\/span>AI Data Processor<\/b>.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

        Building an Automation with the AI Processor<\/b><\/h2>\n

        Getting started with the AI Data Processor in Sheetgo is fast, intuitive, and\u2014most importantly\u2014code-free. Whether you\u2019re cleaning a simple contact list or standardizing columns across a large dataset, here\u2019s how to set up an automatic data cleaning workflow:<\/p>\n

          \n
        1. Connect your source Google Sheets.\u00a0<\/span><\/li>\n
        2. Add the AI data processing step to your workflow<\/span><\/li>\n
        3. Write a prompt describing the tasks you need(e.g., “Make all text in the Full Name column proper case”).<\/span><\/li>\n
        4. Set a destination for your newly cleaned data.<\/span><\/li>\n<\/ol>\n

          That\u2019s it. Sheetgo handles the rest, giving you a clean, reliable, and ready-to-use dataset every time. Let\u2019s see how this works in practice by tackling a couple of real-world scenarios.\u00a0<\/span><\/p>\n

          Use Case 1: Achieving Automatic Data Cleaning for Contact Lists<\/h3>\n

          Before we dive into advanced analysis, let\u2019s start with the most common challenge of all: a messy contact list. This is the perfect first task to see the AI Data Processor\u2019s power and speed in action, turning a chaotic sheet into a standardized list in seconds.\u00a0<\/span><\/p>\n

          The Goal: Take a typical contact list with inconsistent formatting and instantly standardize it for professional use in a CRM, email campaign, or report.\u00a0<\/span><\/p>\n

          What it does:\u00a0<\/b><\/h4>\n
            \n
          • Fixes inconsistent name capitalization (e.g., jANE DOE to Jane Doe).<\/span><\/li>\n
          • Removes extra leading and trailing spaces that break filters and lookups.<\/span><\/li>\n
          • Unifies all date formats into a single, standard format (e.g., YYYY-MM-DD).<\/span><\/li>\n<\/ul>\n

            Sample Google Sheet<\/b><\/h4>\n

            Our goal is to clean up a simple contact list exported from web form, where users have entered their data in various ways.\u00a0<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-24-at-3.52.44-PM-scaled.webp” alt=”automatic data cleaning” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              \n
            1. Create a new Workflow: Start by creating a new workflow in Sheetgo.<\/span><\/li>\n<\/ol>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/4-1-scaled.webp” title_text=”4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              \u00a0 \u00a0 2. Within your new workflow, click to create a new connection.\u00a0<\/span><\/p>\n

              \u00a0 \u00a0 3. Select the source of your data.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-24-at-4.04.45-PM-scaled.webp” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              \u00a0 \u00a0 4. Choose the AI Data Processor <\/span><\/span><\/p>\n

               <\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-20-at-6.02.40-PM.webp” title_text=”Screenshot 2025-07-20 at 6.02.40\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              \u00a0 \u00a0 5. A configuration panel will appear. In the text box, you\u2019ll give the AI its instructions. For our Contact List Cleanup workflow, you would paste the following prompt:<\/span><\/p>\n

              \n

              In the Full Name column, make all text proper case and remove any extra spaces. In the Sign-up Date column, convert all dates to the YYYY-MM-DD format.<\/span><\/p>\n<\/blockquote>\n

              Once done, click on <\/span>Next step<\/b>.\u00a0<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-20-at-6.05.18-PM.webp” title_text=”Screenshot 2025-07-20 at 6.05.18\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” min_height=”43.5px” global_colors_info=”{}” theme_builder_area=”post_content”]

              \u00a0 \u00a0 6. Set the Output destination for your data.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-22-at-8.51.43-PM.webp” title_text=”Screenshot 2025-07-22 at 8.51.43\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              \u00a0 \u00a0 7. Go ahead and click on Run all automations for the workflow to run.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-20-at-6.07.11-PM.webp” title_text=”Screenshot 2025-07-20 at 6.07.11\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              Within moments, your new spreadsheet will be ready. The names will be perfectly capitalized without any extra spaces, and all dates will be in a clean, uniform format, ready for any system you need to import it into.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-22-at-8.53.18-PM.webp” title_text=”Screenshot 2025-07-22 at 8.53.18\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

              Use Case 2: Understand Your Customers with Sentiment Analysis<\/b><\/h3>\n

              Customer feedback can be a goldmine\u2013if you can sort through it. Manually ready every comment to determine the tone is time-consuming. Sheetgo\u2019s AI handles this automatically.\u00a0<\/span><\/p>\n

              It automatically reads customer feedback text and classifies the sentiment as:<\/span><\/p>\n

                \n
              • Positive<\/span><\/li>\n
              • Negative<\/span><\/li>\n
              • Neutral<\/span><\/li>\n<\/ul>\n

                Sample AI Prompt: <\/b>Read the text in the @Customer Feedback column. Create a new column called ‘Sentiment’. Based on the tone and content of the feedback, classify each entry as ‘Positive’, ‘Negative’, or ‘Neutral’.<\/span><\/p>\n

                Sample Google Sheet<\/b><\/h4>\n

                Our goal is to generate a general sentiment of the hundreds of responses received from a customer feedback survey, but reading every single entry isn\u2019t ideal. The Google Sheet contains the Ticket ID and its respective customer feedback.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-22-at-8.54.45-PM-scaled.webp” title_text=”Screenshot 2025-07-22 at 8.54.45\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                Now that we\u2019ve architected our solution, let\u2019s build it. Follow these steps in Sheetgo to learn how to use the <\/span>AI Data Processor<\/b> to perform a sentiment analysis on the data:\u00a0<\/span><\/p>\n

                  \n
                1. Create a new Workflow: Start by creating a new workflow in Sheetgo.<\/span><\/li>\n<\/ol>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/4-1-scaled.webp” title_text=”4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  \u00a0 \u00a0 2. Within your new workflow, click to create a new connection.\u00a0<\/span><\/p>\n

                  \u00a0 \u00a0 3. Select the source of your data.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-22-at-9.11.48-PM.webp” title_text=”Screenshot 2025-07-22 at 9.11.48\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  \u00a0 \u00a0 4. Choose the AI Data Processor <\/span><\/p>\n

                  <\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-16-at-5.12.47-PM-scaled.webp” title_text=”Screenshot 2025-07-16 at 5.12.47\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  A configuration panel will appear. In the text box, you\u2019ll give the AI its instructions. For our sentiment analysis workflow, you would paste the following prompt:<\/span><\/p>\n

                  \n

                  Read the text in the\u00a0 Customer Feedback column. Create a new column called Sentiment. Based on the tone and content of the feedback, classify each entry as Positive, Negative, or Neutral.<\/span><\/span><\/p>\n<\/blockquote>\n

                  Once done, click on <\/span>Next step<\/b>.\u00a0<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-16-at-5.18.40-PM-scaled.webp” title_text=”Screenshot 2025-07-16 at 5.18.40\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  7. Set the Output destination for your data.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-22-at-9.18.01-PM.webp” title_text=”Screenshot 2025-07-22 at 9.18.01\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  \u00a0 \u00a0 8. Go ahead and click on Run all automations for the workflow to run.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-16-at-5.26.46-PM.webp” title_text=”Screenshot 2025-07-16 at 5.26.46\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  Your new spreadsheet will contain the original feedback plus a new <\/span>Sentiment<\/b> column automatically labeled by AI.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-22-at-9.21.05-PM.webp” title_text=”Screenshot 2025-07-22 at 9.21.05\u202fPM” _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

                  Use Case 3: Automatically Categorise Financial Transactions<\/b><\/h3>\n

                  Tired of manually tagging every transaction? Sheetgo AI can analyse your raw financial records and automatically classify each expense into the right category.\u00a0<\/span><\/p>\n

                  The Goal:<\/b> Transform a raw list of transactions into a neatly categorized expense report, saving your finance team hours of manual reconciliation and bookkeeping.<\/span><\/p>\n

                  What it does: <\/b>Looks at transaction descriptions and assigns them to categories like:\u00a0<\/span><\/p>\n