Raise QuickBooks invoices from rows in an Excel billing sheet, saving finance from typing the same figures twice.
Sign in with your Edesy account; the setup wizard opens on this template.
Category
Type
App automation
Steps
2
Apps
Microsoft Excel, QuickBooks
Level
Beginner, about 9 min to set up
Choose the workbook and worksheet (A: invoice number, B: customer, C: amount, E: billing e-mail, F: phone). Each row creates the customer in QuickBooks and then an invoice for the amount. If your customers already exist in QuickBooks, remove the first step and put the QuickBooks customer id in a column instead to avoid duplicates.
Excel: new row
Starts the workflow · Microsoft Excel
QuickBooks: create customer
App action · QuickBooks
QuickBooks: create invoice
App action · QuickBooks
You sign in to Edesy Flow with your Edesy account and the template wizard opens: map each role to a person, pick the app connections it needs, and Flow creates the forms and the workflow for you to edit.
Yes. The workflow opens in the visual builder, where you can add, remove or reorder steps, change who approves, edit the e-mails and add branches.
Make sure every client named on an Asana onboarding task exists in HubSpot, using the task's client name, e-mail and company fields.
1 step · 0 rolesAWeber Subscribers to HubSpotBring new AWeber subscribers into HubSpot as contacts, so webinar and lead-magnet sign-ups reach your CRM.
1 step · 0 rolesCampaign Monitor Subscribers to Zoho LeadsCreate Zoho CRM leads from new Campaign Monitor subscribers, handing engaged newsletter readers to the sales team.
1 step · 0 rolesClickUp Requesters to HubSpotAdd whoever creates a ClickUp task (for example a client using a ClickUp request form) to HubSpot as a contact.
1 step · 0 rolesExcel Customers to Zoho CRMCreate a Zoho CRM contact for each customer added to an Excel billing sheet, keeping the CRM in line with who you actually invoice.
1 step · 0 rolesGmail Enquiries to Pipedrive DealsOpen a Pipedrive person and deal for each sales enquiry that arrives in Gmail, titled after the e-mail subject.
2 steps · 0 roles