{"id":29055,"date":"2022-12-27T17:08:19","date_gmt":"2022-12-27T16:08:19","guid":{"rendered":"https:\/\/clickleo.com\/?p=29055"},"modified":"2023-06-13T15:09:29","modified_gmt":"2023-06-13T13:09:29","slug":"zapier-formatter-utilities","status":"publish","type":"post","link":"https:\/\/clickleo.com\/zapier-formatter-utilities\/","title":{"rendered":"How to Use Zapier Formatter Utilities"},"content":{"rendered":"\n<p>Zapier formatter is a powerful Zapier app. If you\u2019ve ever built anything beyond simple automation, you\u2019ve most likely used it to format text, numbers, or dates. But, contrary to its name, Zapier formatter is not just about formatting the data. With Zapier Formatter Utilities, you can perform different, but just as powerful, operations on your data. Here\u2019s what it\u2019s all about.&nbsp;<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#When_to_Use_Zapier_Formatter_Utilities\" title=\"When to Use Zapier Formatter Utilities&nbsp;\">When to Use Zapier Formatter Utilities&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#Where_to_Find_Formatter_Utilities\" title=\"Where to Find Formatter Utilities\">Where to Find Formatter Utilities<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#How_to_Import_a_CSV_file_with_Zapier\" title=\"How to Import a CSV file with Zapier\">How to Import a CSV file with Zapier<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#How_to_Work_with_Line_Itemizer_in_Zapier\" title=\"How to Work with Line Itemizer in Zapier?\">How to Work with Line Itemizer in Zapier?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#What_Is_the_Subtotal_Property_in_Zapier_Itemizer\" title=\"What Is the Subtotal Property in Zapier Itemizer? \">What Is the Subtotal Property in Zapier Itemizer? <\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#How_to_Turn_Line_Items_to_Text\" title=\"How to Turn Line Items to Text\">How to Turn Line Items to Text<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#How_to_Turn_Text_to_Line_Items\" title=\"How to Turn Text to Line Items\">How to Turn Text to Line Items<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#How_to_Pick_Items_from_a_List_in_Formatter\" title=\"How to Pick Items from a List in Formatter\">How to Pick Items from a List in Formatter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#How_to_Use_Zapier_Lookup_Tables\" title=\"How to Use Zapier Lookup Tables\">How to Use Zapier Lookup Tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/clickleo.com\/zapier-formatter-utilities\/#Get_More_Out_of_Your_Zaps_with_Zapier_Formatter_Utilities\" title=\"Get More Out of Your Zaps with Zapier Formatter Utilities\">Get More Out of Your Zaps with Zapier Formatter Utilities<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"When_to_Use_Zapier_Formatter_Utilities\"><\/span><strong>When to Use Zapier Formatter Utilities&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The utilities event gives you access to a set of distinct transformations. Interestingly, not all of them have much in common (although some are very closely related). However, each of them can be used in a variety of situations.<\/p>\n\n\n\n<p>First, you can use Zapier formatter utilities to import a CSV file. This comes in handy when you need to process its data in one of the other steps in your workflow.&nbsp;<\/p>\n\n\n\n<p>Other options include transformations that let you work with lists and line items.<\/p>\n\n\n\n<p>For example, the pick-from-lists transformation lets pick just the first item from a list of preferences. This comes in handy for example for uploading partial survey data to your CRM or a spreadsheet.<\/p>\n\n\n\n<p>With the Zapier lookup tables (one of my favorite Zapier tools), you can map different values. A common situation when a lookup table proves to be life-saving is a discrepancy between product IDs. A lookup table allows you to map one to the other, and successfully connect the two apps.<\/p>\n\n\n\n<p>Other available Zapier formatter utilities tools all relate to working with lists. They let you turn line items into text (or vice versa) or append\/prepend new values to existing lists of line items. They&#8217;re useful whenever your work involves lists of incoming or outgoing data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Where_to_Find_Formatter_Utilities\"><\/span><strong>Where to Find Formatter Utilities<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To create a Utilities step, start by selecting Formatter from the list of available apps. As you can see, you don\u2019t even need to perform a search to find it:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"741\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/you-can-find-zapier-utilities-in-formatter-1024x741.png\" alt=\"You can find Zapier Utilities in Formatter\" class=\"wp-image-29058\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/you-can-find-zapier-utilities-in-formatter-980x710.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/you-can-find-zapier-utilities-in-formatter-480x348.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Then, open the list of available Zapier Formatter events and select Utilities:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"455\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/a-screenshot-showing-the-selection-of-utilities-1024x455.png\" alt=\"A screenshot showing the selection of Utilities\" class=\"wp-image-29059\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/a-screenshot-showing-the-selection-of-utilities-1024x455.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/a-screenshot-showing-the-selection-of-utilities-980x436.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/a-screenshot-showing-the-selection-of-utilities-480x213.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Next, you can browse the list of all available transformations. As you can see, over half of them relate to working with line items or lists:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"642\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/utilities-provide-a-wide-range-of-transformations-1024x642.png\" alt=\"Utilities offer a wide range of data transformations\" class=\"wp-image-29060\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/utilities-provide-a-wide-range-of-transformations-1024x642.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/utilities-provide-a-wide-range-of-transformations-980x615.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/utilities-provide-a-wide-range-of-transformations-480x301.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Compared to other formatter events, there aren&#8217;t many Zapier utilities transformations. The event lets you:<\/p>\n\n\n\n<ul>\n<li>Import a CSV file<\/li>\n\n\n\n<li>Create, append or prepend items to lists of line items<\/li>\n\n\n\n<li>Pick items from a list<\/li>\n\n\n\n<li>Turn line items to text<\/li>\n\n\n\n<li>Turn text to line items&nbsp;<\/li>\n\n\n\n<li>Create lookup tables and map different sets of values.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>Now, let\u2019s go over each of them to see how they work, and how you can add them to your Zaps.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Import_a_CSV_file_with_Zapier\"><\/span><strong>How to Import a CSV file with Zapier<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Importing a CSV is the first transformation in the Zapier utilities transformations list. To get started, open Zapier Formatter, select the Text event, and pick the transformation from the very top of the list:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"720\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-import-csv-file-option-in-zapier-formatter-1024x720.png\" alt=\"Screenshot showing the import CSV file option in Zapier formatter\" class=\"wp-image-29061\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-import-csv-file-option-in-zapier-formatter-1024x720.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-import-csv-file-option-in-zapier-formatter-980x689.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-import-csv-file-option-in-zapier-formatter-480x338.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Next, you can start setting up the \u201cimport a CSV file\u201d step. As you can see, there are quite a few things you can set:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"812\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/setting-csv-file-options-in-zapier-1024x812.png\" alt=\"Setting CSV file options in Zapier\" class=\"wp-image-29062\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/setting-csv-file-options-in-zapier-980x777.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/setting-csv-file-options-in-zapier-480x381.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>First, you want to enter the input file pulled in one of the previous steps. In this example, we\u2019re uploading it from Google drive.<\/p>\n\n\n\n<p>Next, you can choose whether you want to force Zapier to use the first row as a header row. Zapier should detect it automatically, but if it does not, you want to select \u201cyes\u201d in this step.<\/p>\n\n\n\n<p>Then, you can choose the type of CSV file. There are several options to choose from:<\/p>\n\n\n\n<ul>\n<li>You can ask Zapier to detect the type automatically (preferred option, especially if you want to create a dynamic workflow).<\/li>\n\n\n\n<li>A comma-delimited file<\/li>\n\n\n\n<li>A semicolon-delimited file<\/li>\n\n\n\n<li>An Excel-comma-delimited file<\/li>\n\n\n\n<li>Excel-tab-delimited file<\/li>\n\n\n\n<li>A one-column file<\/li>\n\n\n\n<li>A text file<\/li>\n<\/ul>\n\n\n\n<p>In our case, we asked Zapier to detect the file type for us:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-different-commands-for-csv-file-in-zapier-1024x605.png\" alt=\"A screenshot showing the different commands for CSV file in Zapier\" class=\"wp-image-29063\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-different-commands-for-csv-file-in-zapier-1024x605.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-different-commands-for-csv-file-in-zapier-980x579.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-different-commands-for-csv-file-in-zapier-480x284.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Lastly, you can choose the encoding type. In most cases, you can use the default UTF-8. The two other options, Latin-1 and UTF-16, are much rarer than the other one.<\/p>\n\n\n\n<p>And here\u2019s what the output of a sample list of old cars looks like:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"399\" height=\"626\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-provided-by-zapier-after-processing-csv-file-automatically.png\" alt=\"Output provided by Zapier after processing CSV file automatically\" class=\"wp-image-29064\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-provided-by-zapier-after-processing-csv-file-automatically.png 399w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-provided-by-zapier-after-processing-csv-file-automatically-191x300.png 191w\" sizes=\"(max-width: 399px) 100vw, 399px\" \/><\/figure>\n\n\n\n<p>One quick note &#8211; this step will not be useful for processing large CSV files. Unfortunately, Zapier is unable to import CSV files larger than 150 KB:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"174\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-will-not-allow-to-upload-a-large-size-file-1024x174.png\" alt=\"Zapier does not allow uploading of large CSV files\" class=\"wp-image-29065\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-will-not-allow-to-upload-a-large-size-file-1024x174.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-will-not-allow-to-upload-a-large-size-file-980x167.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-will-not-allow-to-upload-a-large-size-file-480x82.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>In this case, you\u2019ll have to split the file before importing it.&nbsp;<\/p>\n\n\n\n<p>However, the step is perfect if you plan to regularly import data from your CRM, online store, or other sources. That is before the file gets too big.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Work_with_Line_Itemizer_in_Zapier\"><\/span><strong>How to Work with Line Itemizer in Zapier?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The next available transformation is the line itemizer. It creates a new line item array out of multiple existing strings of texts or arrays.<\/p>\n\n\n\n<p>To get started, select Line Itemizer from the list of available Zapier transformations:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"259\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-can-be-used-as-line-itemizer-1024x259.png\" alt=\"Line itemizer - one of Zapier Formatter Utilities transformations\" class=\"wp-image-29069\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-can-be-used-as-line-itemizer-1024x259.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-can-be-used-as-line-itemizer-980x248.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-can-be-used-as-line-itemizer-480x122.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Next, look at the available options. First, you\u2019ll be asked to enter the line item group name. In our example, we\u2019ll name the group \u201cCars for sale\u201d. Then, we add three distinct data sets &#8211; Mileage, Price, and Year.<\/p>\n\n\n\n<p>The three data sets are line items that come from an imported CSV. But, we want to add a few more data pieces to each set. Itemizer allows us to merge existing comma-delimited data with the data added manually:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"965\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-settings-of-zapier-itemizer-1024x965.png\" alt=\"A screenshot showing settings of Zapier itemizer\" class=\"wp-image-29071\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-settings-of-zapier-itemizer-980x923.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-settings-of-zapier-itemizer-480x452.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>The two other questions in this Zap relate to the subtotal property. In our case, we don\u2019t need that. But, it\u2019s a very handy feature that we\u2019ll discuss later in this guide to Zapier formatter utilities.&nbsp;<\/p>\n\n\n\n<p>As you can see in the output, the manually-added data is now part of the original lists of line items:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"445\" height=\"639\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-provided-by-zapier-itemizer.png\" alt=\"A screenshot showing the Output provided by Zapier itemizer\" class=\"wp-image-29072\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-provided-by-zapier-itemizer.png 445w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-provided-by-zapier-itemizer-209x300.png 209w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<p>Keep in mind that the manually input data is just an example. This step can be used to connect comma-delimited data or line items from different sources. This allows you to create complete data sets dynamically.<\/p>\n\n\n\n<p>For example, you could create a new group of line items by connecting Google sheets with the imported CSV data. As it is in most cases with Zapier, the sky&#8217;s the limit!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Is_the_Subtotal_Property_in_Zapier_Itemizer\"><\/span><strong>What Is the Subtotal Property in Zapier Itemizer? <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Now, let\u2019s get back to the option that we previously skipped &#8211; the Subtotal property.&nbsp;<\/p>\n\n\n\n<p>By using this option, you can automatically calculate the subtotal value. This is useful when the destination app requires a total amount (and when the source app doesn\u2019t provide it).&nbsp;<\/p>\n\n\n\n<p>To force Zapier to automatically calculate the value, you need to map your data sets to properties called price and quantity (or Qnt). Of course, don\u2019t forget to set \u201cCreate Subtotal Property\u201d to a \u201cYes\u201d:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"882\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-can-automatically-calculate-subtotal-value-1024x882.png\" alt=\"Zapier itemizer can automatically calculate subtotal value\" class=\"wp-image-29073\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-can-automatically-calculate-subtotal-value-1024x882.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-can-automatically-calculate-subtotal-value-980x845.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-can-automatically-calculate-subtotal-value-480x414.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>As you can see, Zapier created a new property AND calculated the total value:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"341\" height=\"624\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-obtained-by-zapier-itemizer-after-creating-a-sub-value.png\" alt=\"Screenshot showing the output provided by Zapier Itemizer after calculating the subtotal value\" class=\"wp-image-29074\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-obtained-by-zapier-itemizer-after-creating-a-sub-value.png 341w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-obtained-by-zapier-itemizer-after-creating-a-sub-value-164x300.png 164w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/figure>\n\n\n\n<p>Of course, this substep can also be used to merge data from different sources and calculate the subtotal value automatically. Just be aware that the quantities have to be higher than 1.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Turn_Line_Items_to_Text\"><\/span><strong>How to Turn Line Items to Text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The next step allows you to turn line items into text separated with a separator of your choice. It also returns each item individually. This allows you to use individual items in future steps.&nbsp;<\/p>\n\n\n\n<p>Just keep in mind that if you pick the first item from the list, all future zap runs will be using the first item from this step\u2019s output. So, how do you get started?&nbsp;<\/p>\n\n\n\n<p>As usual, start by selecting the right transformation from the dropdown list. In our case, we want the Line item to text one:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"250\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-turn-line-items-into-text-separated-with-a-separator-of-your-choice-1024x250.png\" alt=\"Zapier allows you to turn line items into text separated with a separator of your choice \" class=\"wp-image-29075\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-turn-line-items-into-text-separated-with-a-separator-of-your-choice-1024x250.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-turn-line-items-into-text-separated-with-a-separator-of-your-choice-980x239.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-turn-line-items-into-text-separated-with-a-separator-of-your-choice-480x117.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Next, you will be asked to provide the input data source and a separator. In our case, we want to split the data with a new line. The [:newline:] is one of Zapier\u2019s special characters:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"461\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-value-and-seprator-1024x461.png\" alt=\"Setting of the Line-item to text transformation - a data set and a separator\" class=\"wp-image-29076\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-value-and-seprator-1024x461.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-value-and-seprator-980x441.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-value-and-seprator-480x216.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>And here\u2019s the output of the transformation:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"288\" height=\"549\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-by-zapier-after-line-item-to-text-transformation.png\" alt=\"Output provided by Zapier after line item to text transformation\" class=\"wp-image-29077\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-by-zapier-after-line-item-to-text-transformation.png 288w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-by-zapier-after-line-item-to-text-transformation-157x300.png 157w\" sizes=\"(max-width: 288px) 100vw, 288px\" \/><\/figure>\n\n\n\n<p>Of course, you are free to choose a different separator, such as a comma or semicolon. The main advantage of this transformation is that it makes data easier to use and manipulate.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Turn_Text_to_Line_Items\"><\/span><strong>How to Turn Text to Line Items<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now, let\u2019s look at the opposite of the previous step. This time, we want to turn text into line items. To get started, first pick the Text to Line item from the Zapier formatter transformation list. Note that it doesn\u2019t appear immediately next to its opposite transformation:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"158\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-allows-you-to-transform-text-to-line-item-1024x158.png\" alt=\"Zapier formatter allows you to transform text to line item\" class=\"wp-image-29078\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-allows-you-to-transform-text-to-line-item-1024x158.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-allows-you-to-transform-text-to-line-item-980x151.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-itemizer-allows-you-to-transform-text-to-line-item-480x74.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>For the Zap to work, the text has to be comma delimited. In our example, we\u2019re reusing the data that we generated in the previous step. We just changed the separator to a comma compared to the example:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"320\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-zapier-text-to-line-transformation-in-itemizer-1024x320.png\" alt=\"A screenshot showing the input for Zapier text to line transformation in Formatter Utilities\" class=\"wp-image-29079\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-zapier-text-to-line-transformation-in-itemizer-1024x320.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-zapier-text-to-line-transformation-in-itemizer-980x306.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-for-zapier-text-to-line-transformation-in-itemizer-480x150.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>And here\u2019s the output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"133\" height=\"278\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-output-obtained-after-text-to-line-transformation-in-zapier-itemizer.png\" alt=\"The output of the text to line item transformation in Zapier Formatter Utilities\" class=\"wp-image-29080\"\/><\/figure>\n\n\n\n<p>Keep in mind that not all apps will accept text, just like not all of them will accept line items. That\u2019s why it\u2019s important to understand the input data that your app accepts before you get to building a Zap.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Pick_Items_from_a_List_in_Formatter\"><\/span><strong>How to Pick Items from a List in Formatter<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now, let\u2019s look at how you can use Zapier Formatter utilities to pick individual items from a list. Of course, you could always split that list into separate items. But unless you need to be very specific, there\u2019s no need to do that.<\/p>\n\n\n\n<p>First, select the \u201cPick from list\u201d transformation:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"256\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-formatter-utilities-can-be-used-to-pick-individual-items-from-a-list-1-1024x256.png\" alt=\"Zapier Formatter utilities can be used to pick individual items from a list\" class=\"wp-image-29082\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-formatter-utilities-can-be-used-to-pick-individual-items-from-a-list-1-1024x256.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-formatter-utilities-can-be-used-to-pick-individual-items-from-a-list-1-980x245.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-formatter-utilities-can-be-used-to-pick-individual-items-from-a-list-1-480x120.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Next, you\u2019ll be asked to fill in the details. As you can see, there\u2019s not much to fill:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"602\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-details-to-pick-individual-items-from-a-list-1024x602.png\" alt=\"A screenshot showing the input details to pick individual items from a list\" class=\"wp-image-29083\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-details-to-pick-individual-items-from-a-list-1024x602.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-details-to-pick-individual-items-from-a-list-980x576.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-details-to-pick-individual-items-from-a-list-480x282.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>&nbsp;The transformation allows you to select one of three different operations. Zapier can choose the first item, the last one, or a random one. In our case, we asked it to pick the first one:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"251\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-three-different-options-for-pickup-from-list-transformation-1024x251.png\" alt=\"The three different options to choose for pick from the list Zapier transformation\" class=\"wp-image-29084\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-three-different-options-for-pickup-from-list-transformation-1024x251.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-three-different-options-for-pickup-from-list-transformation-980x241.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-three-different-options-for-pickup-from-list-transformation-480x118.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>And here\u2019s the output &#8211; as you can see, it\u2019s equal to the first value in the list that we provided in this step:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"146\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-pick-from-list-transformation-1024x146.png\" alt=\"The output of the pick from list transformation\" class=\"wp-image-29085\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-pick-from-list-transformation-1024x146.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-pick-from-list-transformation-980x139.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-pick-from-list-transformation-480x68.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Use_Zapier_Lookup_Tables\"><\/span><strong>How to Use Zapier Lookup Tables<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now, let\u2019s look at one of the most powerful and useful Zapier formatter steps &#8211; the lookup tables. The tables are pretty powerful and allow you to map different types of data. This is critical in ensuring that you connect the right data sets.<\/p>\n\n\n\n<p>For example, you can map the different IDs and SKUs of products or services in different apps. Similarly, you can map users between two different apps, making it easier to update them.<\/p>\n\n\n\n<p>In fact, the number of use cases for the lookup tables is endless &#8211; and it all depends on your individual needs. So, how do you get started with the lookup tables?<\/p>\n\n\n\n<p>First, select the Lookup Table from the transformations list:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"248\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-map-data-using-lookup-tables-1-1024x248.png\" alt=\"Zapier allows you to map data using Lookup tables\" class=\"wp-image-29087\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-map-data-using-lookup-tables-1-1024x248.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-map-data-using-lookup-tables-1-980x237.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/zapier-allows-you-to-map-data-using-lookup-tables-1-480x116.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>Next, you\u2019re ready to start building the table. First, you want to set the lookup key. It\u2019s a dynamic value that you receive in one of the previous steps.&nbsp;<\/p>\n\n\n\n<p>In our case, the lookup key is a service ID inside SPP. We then map different service IDs to their respective ClickUp task templates IDs:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"869\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-options-for-lookup-tables-1024x869.png\" alt=\"A screenshot showing a sample configuration of lookup tables\" class=\"wp-image-29088\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-options-for-lookup-tables-1024x869.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-options-for-lookup-tables-980x831.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/screenshot-showing-the-input-options-for-lookup-tables-480x407.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>We also set a Fallback value. It\u2019s used if Zapier is unable to locate the value for the lookup key in the table.<\/p>\n\n\n\n<p>And here\u2019s the output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"114\" src=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-lookup-table-transformation-in-zapier-formatter-utilities-1024x114.png\" alt=\"Output of the lookup table transformation in Zapier formatter Utilities\" class=\"wp-image-29089\" srcset=\"https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-lookup-table-transformation-in-zapier-formatter-utilities-1024x114.png 1024w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-lookup-table-transformation-in-zapier-formatter-utilities-980x110.png 980w, https:\/\/clickleo.com\/wp-content\/uploads\/2022\/12\/output-obtained-after-the-lookup-table-transformation-in-zapier-formatter-utilities-480x54.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<p>As you can see, it\u2019s the same value that got mapped to service ID 13.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Get_More_Out_of_Your_Zaps_with_Zapier_Formatter_Utilities\"><\/span><strong>Get More Out of Your Zaps with Zapier Formatter Utilities<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>And that\u2019s it! You now know all the transformations available inside Zapier formatter utilities. Now you are ready to manipulate lists of items, create lookup tables, and import CSV files.&nbsp;<\/p>\n\n\n\n<p>Still, let\u2019s not forget that Zapier formatter is more than just the utilities features. To learn all the ins and outs of it, don\u2019t miss the other guides in the Zapier Formatter series:&nbsp;<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/clickleo.com\/introduction-to-zapier-formatter\/\">Introduction to Zapier Formatter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/clickleo.com\/format-date-time-zapier-formatter\/\">Guide to manipulating date and time in Zapier<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/clickleo.com\/format-numbers-zapier-formatter\/\">Guide to manipulating numbers in Zapier<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/clickleo.com\/format-text-zapier-formatter\/\">Guide to manipulating text in Zapier<\/a><\/li>\n<\/ul>\n\n\n\n<p>Naturally, learning all of that will take time &#8211; and you\u2019ve got a business to run. Thankfully, you don\u2019t have to do all the Zapier work on your own.&nbsp;<\/p>\n\n\n\n<p>Hire a professional Zapier consultant and let them do the work for you. All that while you focus on the things that you\u2019re the best at.<\/p>\n\n\n\n<p>To get started, head over to <a href=\"https:\/\/clickleo.com\/schedule-a-call\/\">this page<\/a> and get in touch. Let\u2019s talk about your business and automation projects.<\/p>\n\t\t\t<input type=\"hidden\" id=\"wplinkpress-user-email\" value=\"\" \/>\n<input type=\"hidden\" id=\"wplinkpress-authorize-url\" value=\"https:\/\/www.linkedin.com\/oauth\/v2\/authorization?response_type=code&client_id=77o0kge0jykokv&redirect_uri=https%3A%2F%2Fclickleo.com%2Fauthorize-linkedin%2F&state=https%3A%2F%2Fclickleo.com%2Fwp-json%2Fwp%2Fv2%2Fposts%2F29055&scope=r_liteprofile%20r_emailaddress%20w_member_social\" \/>\n<input type=\"hidden\" id=\"wplinkpress-post-id\" value=\"29055\" \/>\n<div class=\"ui wplinkpress comments\">\n<h3 class=\"ui dividing header\">Comments<\/h3>\n<form id=\"add-wplinkpress-comment\" method=\"POST\"> \n<div class=\"comment add-comment\">\n\t<a class=\"avatar\"><img src=\"https:\/\/clickleo.com\/wp-content\/plugins\/wplinkpress\/assets\/media\/non-user-icon.jpg\" \/><\/a>\n\t<div class=\"content\">\n\t<textarea id=\"wplinkpress-comment-text-0\" class=\"wplinkpress-comment-text\" style=\"width:100%;\" placeholder=\"Add a comment...\"><\/textarea>\n\t<div class=\"bottom-layer\">\n\t\t<div class=\"comment-atts\" style=\"float:left;\">\n\t\t\t\t<div class=\"feed-share\">\n\t\t<label class=\"switch tips\">\n\t\t\t<input type=\"checkbox\" id=\"toggle-linkedin-feed\" >\n        \t<span class=\"slider round\"><\/span>\n\t\t<\/label>\n\t\t<span>Share on activity feed<\/span>\n\t\t<\/div>\n\t\t<\/div>\n\t<div class=\"wplinkpress_buttons\">\n\t\t<button id=\"authorize_comment_0\" class=\"authorize_comment\" disabled=\"disabled\">Post with LinkedIn<\/button>\n\t\t<\/div>\n\t<\/div>\n\t<\/div>\n<\/div>\n<\/form>\n<h3 class=\"ui dividing header\"><span class=\"wplinkpress-brand\">Powered by WP LinkPress<\/span><\/h3>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Zapier formatter is a powerful Zapier app. If you\u2019ve ever built anything beyond simple automation, you\u2019ve most likely used it to format text, numbers, or dates. But, contrary to its name, Zapier formatter is not just about formatting the data. With Zapier Formatter Utilities, you can perform different, but just as powerful, operations on your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":29795,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"1080","footnotes":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/posts\/29055"}],"collection":[{"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/comments?post=29055"}],"version-history":[{"count":4,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/posts\/29055\/revisions"}],"predecessor-version":[{"id":29803,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/posts\/29055\/revisions\/29803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/media\/29795"}],"wp:attachment":[{"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/media?parent=29055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/categories?post=29055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clickleo.com\/wp-json\/wp\/v2\/tags?post=29055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}