Log completed Housecall Pro jobs to a Google Sheet daily

Every day at 7pm, build a running revenue and production log from my completed Housecall Pro jobs by appending one row per job to a Google Sheet, with zero manual data entry. Let me choose the spreadsheet, the tab, and the exact time this runs each day.

Use the Housecall Pro List Jobs operation to fetch the jobs from that day, filtered to the current date. Keep only the jobs whose work_status is complete, and ignore anything that is unscheduled, scheduled, in progress, or canceled.

For each completed job, append one row to my chosen Google Sheet tab using the Google Sheets Append Values operation. Keep the column order fixed and identical every day so the sheet stays clean: completion date, customer name, job type or service, the assigned technician(s), and the job total in dollars.

Housecall Pro returns job totals as integers in cents (for example, total_amount), so divide the total by 100 to convert it into dollars before writing it. If a job has more than one assigned technician, list all of them together in the technician column.

Append the rows without overwriting anything that is already in the sheet, so the log accumulates a growing day-by-day history of completed work and total revenue.