{"id":8631,"date":"2021-10-15T14:05:00","date_gmt":"2021-10-15T12:05:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=8631"},"modified":"2021-10-15T14:05:00","modified_gmt":"2021-10-15T12:05:00","slug":"generateur-de-factures","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/sales-templates\/invoice-generator\/","title":{"rendered":"Comment cr\u00e9er un g\u00e9n\u00e9rateur de factures"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;27px|0px|28px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Generating invoices is a fundamental process for many businesses when it comes to billing clients and collecting receipts. However, manually creating these invoices every month is a monumental task that demands a lot of time &#8211; something that businesses don\u2019t have. The solution: an invoice generator.<\/p>\n<p>For example, let\u2019s say I have a huge list of clients that purchase a variety of your products per month. Rather than manually entering hundreds of invoices for your clients, I can make my own invoice generator that can automatically transfer my clients\u2019 order data to create accurate, custom invoices, bills, or invoicing receipts immediately. As a result, I can save time on manual input and focus on receiving client payments.<\/p>\n<p>An invoice generator is an essential tool for any business. Interested in learning how to create invoices automatically? Let\u2019s look in more detail at how you can create your custom invoice generator with Sheetgo.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is an invoice generator?<\/h2>\n<p>An invoice generator is an intelligent tool that automatically creates your business\u2019 invoices using the data you provide. An invoice generator usually allows you to create an invoice template as the foundation for every invoice. It then takes the data you insert into a file and then transfers this data into the corresponding areas of your template.<\/p>\n<p>At this point, your invoices are automatically created, ready to send out to your clients. With an invoice generator, not only are you saving time, but you are also eliminating human error, which is particularly important.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Sign up for Sheetgo and start automating your entire <span style=\"background-color: rgba(41,121,255,0.2);\"><span>invoicing<\/span><\/span> process<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/invoice-generator&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;27px|0px|28px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Why use an invoice generator?<\/h2>\n<p>Invoice generators provide a much more comprehensive solution than just an invoice template you create on a spreadsheet or document. Usually, invoice generators can automate the entire process for you, also providing extra support when it comes to sending the invoices and receiving status updates, such as when the invoice has been received or paid.<\/p>\n<p>Here are the main benefits of opting for an invoice generator over a simple invoicing template:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ul>\n<li><b>Save time:<\/b> Unlike invoicing templates which still require manual input, an invoicing generator will transfer invoicing data from a file (usually a spreadsheet) and add it to the template automatically, saving you hours of work.<\/li>\n<li><b>Avoid human error:<\/b> The automated process carried out by invoice generators means there is no risk of human error caused by manual copy and pasting of data.<\/li>\n<li><b>Easily customizable:<\/b> You have a wide selection of ready-made templates that you can easily customize to suit your needs and objectives. For example, you will be able to add additional lines or columns for other variables, such as item descriptions.<\/li>\n<li><b>Additional features:<\/b> A lot of invoice templates may have additional features such as automatic mail merging or insights into your payment methods. You can usually track the status of your invoices sent to clients.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now that you know why invoice generators are the best option when it comes to streamlining your invoicing process, let\u2019s take a look at how you can make your own invoice generator using your everyday tools!<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to create an invoice generator<\/h2>\n<p>There are many invoice generator tools on the market to help set up invoices that you can implement into your business operations.<\/p>\n<p> Although these can be extremely helpful, creating your own custom invoice generator offers the ability to optimize the invoice generation process to meet your specific objectives.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h3>Why use Sheetgo to automate invoices?<\/h3>\n<p>Sheetgo created its very own fully developed <a href=\"https:\/\/www.sheetgo.com\/solutions\/crm\/invoice-generator\/\" target=\"_blank\" rel=\"noopener\">invoice generator workflow<\/a> that you can easily implement and customize into your organization. Sheetgo automatically generates new invoices from a Google spreadsheet, which is connected to other tools to create, convert and send the invoice directly to your clients.<\/p>\n<p>Here are just some benefits of using the Sheetgo invoice generator:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ul>\n<li><b>Automated workflow from start to finish:<\/b> Sheetgo offers an entire workflow that takes you from entering invoice data, all the way to sharing the final product with recipients. You can complete your entire invoice process in just a few clicks of a button.<\/li>\n<li><b>Use Sheetgo Forms to input data automatically into your invoice document:<\/b> Sheetgo provides useful forms where you can input your invoice data. Sheetgo then automatically inserts this data into an invoice document template, ready to be shared.<\/li>\n<li><b>Turn your invoices into a PDF:<\/b> Using Sheetgo\u2019s document generation feature, you can turn your invoice sheets into invoice PDFs &#8211; the perfect file format to send to your clients.<\/li>\n<li><b>Automatically send invoices via Gmail:<\/b> This integration with Gmail means you can automatically send invoices via Gmail to specific recipients with ease.<\/li>\n<li><b>Customize and build on your workflow to suit your needs:<\/b> Workflows are developed with customization in mind. You can easily build on your workflow and adapt it you your business needs, so you get the most out of your invoice generation.<\/li>\n<li><b>Easy use with existing tools:<\/b> The entire workflow runs based on connections between Google Sheets, Google Docs, and Gmail; tools that are well-known and used by users already.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h3>Step-by-step guide on how to create an invoice generator with Sheetgo<\/h3>\n<p>The best thing about <a href=\"https:\/\/www.sheetgo.com\/solutions\/crm\/invoice-generator\/\" target=\"_blank\" rel=\"noopener\">the Sheetgo invoice generator<\/a> is that the hard work is already done for you; you simply have to customize the invoicing templates for your business. This is a simple, more effective alternative to learning how to create an invoice in Excel or Google Sheets.<\/p>\n<p>Use the following step-by-step guide on how to use the Sheetgo web app to create and run your online invoice generator.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>1. Install the invoice generator within the Sheetgo web app<\/h4>\n<p>To access the new invoice generator template for free, simply click on the signup button below. The spreadsheet-based invoice generator template will be installed on your Google Drive.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/invoice-generator&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|30px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]It takes you to the Sheetgo web application where you can sign up for Sheetgo with your Google, Dropbox, or Microsoft account.<\/p>\n<p>After that, you enter the invoice generator installation screen.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGA.png&#8221; alt=&#8221;invoice generator install template&#8221; title_text=&#8221;IGA&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Here, click <b>Install template<\/b>. The following message will pop up:[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#e4f4f9&#8243; custom_padding=&#8221;20px|20px|20px|20px|true|true&#8221; border_color_all=&#8221;#6ae8ff&#8221; border_width_left=&#8221;5px&#8221; border_color_left=&#8221;#00b6ff&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<b>Google Account Authorization<\/b><\/p>\n<p>In order to proceed with the installation of this template, you need to authorize Sheetgo to create the spreadsheets into your Google Drive account.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Simply authorize Sheetgo to add the invoice generator to your Google Drive.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h4>2. Edit the Google Docs invoice template<\/h4>\n<p>Sheetgo provides a ready-made invoice document template with variable placeholders in a Google Doc. Here, the data submitted by the Sheetgo forms will replace these placeholders to create your custom invoices. You can access the Google Docs invoice template in your Google Drive by navigating to <b>Sheetgo templates &gt; Invoice generator &gt; Invoice generator document<\/b>. In this document, you can edit the various features to reflect your company, such as the logo and your company details.<\/p>\n<p><b>Please note:<\/b> If you would like to customize your invoice document further (for example, creating new columns\/rows or adding new variable placeholders), you can do so. However, you must make sure that any new variable placeholders must also be added as a new column within the corresponding spreadsheet.<\/p>\n<p>To learn more about how to make an invoice template for your invoice generation solution, check out our support page on <a href=\"https:\/\/support.sheetgo.com\/en\/articles\/8529703-how-to-generate-documents-with-sheetgo\" target=\"_blank\" rel=\"noopener\">how to generate documents<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGB.png&#8221; alt=&#8221;Invoice generator document&#8221; title_text=&#8221;IGB&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>3. Input your invoicing data using Sheetgo Forms<\/h4>\n<p>Open up the Invoice generator template database and delete the mock invoice data. It\u2019s now time to add your own invoicing data. Sheetgo has three ready-made forms for different areas of your operations. These forms are made up of fields which correspond to the columns in your Google Sheets invoicing spreadsheet. This means that when you enter invoicing data into your form and submit it, the data is automatically assigned to the correct column in the spreadsheet, and each form appears as a new row.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start automating your entire <span style=\"background-color: rgba(41,121,255,0.2);\"><span>invoicing<\/span><\/span> process<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/invoice-generator&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;27px|0px|28px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Each form is sent to its corresponding tab within the invoice generator dashboard Here are the 3 forms you can add data to:<\/p>\n<p><b><\/b><\/p>\n<ol>\n<li><b>Register client:<\/b> First, use this form to register any new clients and their information<\/li>\n<li><b>Register item:<\/b> Register all of the items in your inventory<\/li>\n<li><b>Register invoice:<\/b> Fill out these forms once your clients and items are registered. These use the client and item data to complete the form.<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGC.png&#8221; alt=&#8221;invoice generator template Sheetgo forms&#8221; title_text=&#8221;IGC&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>If you already have an existing billing spreadsheet full of data (for example, a database of client information, or items list), you can copy and paste your data directly into the spreadsheet database.<\/p>\n<p>Make sure that you add the correct data to its corresponding column.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>4. Edit your connection<\/h4>\n<p>Now that you have inputted your data via the forms, you can now choose to edit your connections to fit them to your needs. Under the Connection tab of your workflow overview, press the <b>More options icon (\u22ee)<\/b>. Select <b>Edit<\/b>. This will give you an overview of how each file is connected, and where your documents will be saved.<\/p>\n<p>There are many adaptations you can make, for example, changing the file location for our newly generated invoices and PDFs. For this, navigate to the <b>Destination folder<\/b> section under the <b>Generate<\/b> process. Here, you can choose and rename a folder for all of your generated invoices.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#e4f4f9&#8243; custom_padding=&#8221;20px|20px|20px|20px|true|true&#8221; border_color_all=&#8221;#6ae8ff&#8221; border_width_left=&#8221;5px&#8221; border_color_left=&#8221;#00b6ff&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<b>Google Account Authorization<\/b><\/p>\n<p>In order to proceed with the installation of this template, you need to authorize Sheetgo to create the spreadsheets into your Google Drive account.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>5. Add your invoicing client contacts to the Gmail integration<\/h4>\n<p>Similar to the step above, you can use the <b>Edit<\/b> feature of your workflow to add contacts to the Gmail integration. Under the <b>Share<\/b> process, you can manually add your contacts to the Gmail integration by selecting <b>Use custom recipients<\/b>.<\/p>\n<p>Otherwise, Sheetgo will automatically send out your invoices through the dynamic data, by using one of the columns from your spreadsheet (in this case, Column D: Client email address). You can also customize other settings as well, such as your sending method and email subject line.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGD.png&#8221; alt=&#8221;invoice generator send via Gmail&#8221; title_text=&#8221;IGD&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>6. Generate your invoices<\/h4>\n<p>Now that you have customized the invoice generator workflow to your needs, you can now run the workflow to start the invoice generation process. Sheetgo will now update the entire system with your new data.<\/p>\n<p>As a result, you should now see a spreadsheet with all of your new data, a folder of individual invoices saved as PDFs, and emails with each invoice sent to the corresponding recipients.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start automating your entire <span style=\"background-color: rgba(41,121,255,0.2);\"><span>invoicing<\/span><\/span> process<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/invoice-generator&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;27px|0px|28px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGE.png&#8221; alt=&#8221;invoice generator PDFs&#8221; title_text=&#8221;IGE&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>7. Automate your workflow<\/h4>\n<p>Sheetgo allows you to schedule the frequency of automated transfers in your workflow so that you constantly receive the latest data. You can alter the transfer frequency to match the frequency of your invoices (weekly, monthly, etc.)<\/p>\n<p>To do this, enter the Workflow tab and click on the button labelled <b>Automate<\/b> near the bottom of the screen. Slide the button <b>Run automatically<\/b> and select the frequency of your transfers in days and hours. Once you\u2019re happy with the estimated number of transfers per month, press Save.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGF.png&#8221; alt=&#8221;invoice generator automatic updates&#8221; title_text=&#8221;IGF&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>8. View your metrics<\/h4>\n<p>You can also access metrics to monitor how your inventory is affected by your invoices. Simply click the <b>Metrics<\/b> tab in the menu on the right-hand side of your screen. Here, you will find important information such as the total invoices issued in a month, your top clients, and even your top selling items.<\/p>\n<p>Your workflow is now complete! From now on, every time you enter new data into your spreadsheet via forms, Sheetgo will create, generate and share the custom invoice automatically. You can then monitor your invoices under the metrics tab![\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/IGG.png&#8221; alt=&#8221;invoice generator metrics dashboard&#8221; title_text=&#8221;IGG&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>There you have it!<\/h3>\n<p>Now you have your very own custom invoice generator workflow that automatically handles the entire invoice generation process! This is a great alternative for those who don\u2019t want to waste time and manual effort on learning how to make invoices in Excel or Google Sheets. With a combination of Sheetgo forms, spreadsheet dashboard, invoice template and Gmail integration, you have a fully automated workflow that creates, generates, sends and tracks all of your invoices for you!<\/p>\n<p>If you would like to access more of Sheetgo\u2019s latest workflow templates, why not take a look at our article on the <a href=\"https:\/\/www.sheetgo.com\/blog\/inventory-templates\/inventory-system-with-barcode-scanner\/\">Sheetgo inventory system with barcode scanner<\/a>! Alternatively, discover more blog posts on how to solve with Sheetgo below!<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.22.2&#8243; background_color=&#8221;#f9f9ff&#8221; custom_margin=&#8221;40px||40px||false|false&#8221; custom_padding=&#8221;15px|25px|15px|25px|true|true&#8221; border_width_left=&#8221;3px&#8221; border_color_left=&#8221;#808e95&#8243; global_module=&#8221;26540&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><em><strong>Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Start automating your entire <span style=\"background-color: rgba(41,121,255,0.2);\"><span>invoicing<\/span><\/span> process<\/h3>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/invoice-generator&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Generating invoices is a fundamental process for many businesses when it comes to billing clients and collecting receipts. However, manually creating these invoices every month is a monumental task that demands a lot of time &#8211; something that businesses don\u2019t have. The solution: an invoice generator. For example, let\u2019s say I have a huge list [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":37229,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[62],"tags":[50,43],"class_list":["post-8631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sales-templates","tag-finance","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8631"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8631\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/37229"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}