As far as I know, the only viable option is to use the BigQuery export. There’s no real-time API for this and the Cloud Billing API doesn’t support that use case either.
Some might suggest building your own solution or relying on third-party tools that parse logs and attempt to forecast usage but that’s more of a workaround than a reliable method.
Why are my usage date costs different than my invoice month costs?
Google Cloud products report usage and cost data to Cloud Billing processes at varying intervals. As a result, you might see a delay between your use of Google Cloud services, and the usage and costs being available to view in Cloud Billing. Typically, your costs are available within a day, but can sometimes take more than 24 hours.
At the end of a calendar month, late-reported usage might not be included on that month’s invoice and instead might roll over to the next month’s invoice.
When you view your online reports, usage is shown by the actual usage date, which might be different from the invoice month.