How to update existing records in Zoho CRM with a daily routine?

How to update existing records in Zoho CRM with a daily routine?

Hello, 

I am having invoices in the regular "Invoices" module in Zoho CRM and I am looking for a way to retrieve the current invoice/payment status from an external account tool. 

So my plan was that two times a day there is an automatic routine that retrieves the current payment status from the invoices (from the external account tool) and sync it to the corresponding invoice in Zoho CRM. 

Is that possible somehow?

Thanks, M.