Automate invoices by reading input table with names & price
Hello,
I have a set of garages where I have to send monthly invoices as a PDF. I would like to automate this process through numbers + Automator using the following approach:
I have a table “customer data” with n rows (for n customers) with certain columns (name, address, monthly rate…). Then there is a general template for the invoice with placeholders for the client-specific data. The idea is now to go through the table “customer data” line by line and read the customer-specific data and paste it in the according cells on the template. Then, for each invoice created, the invoice number on the template is increased by 1 and the document is saved as a pdf, using date and name of the customer as file name. I am completely new to Automator but found sth similar once in VBA for Excel.
Is the described process sth that would be feasible in numbers + Automator? Can you recommend Andy examples that I could use to copy some code together?
Thanks and regards
Johannes
MacBook Pro (2020 and later)