PLDT Bill to Google Sheets
This will work, provided you are receiving your PLDT bills in your gmail account like this.
In Google Sheets, in a sheet named Sheet1 (default sheet name), put the following column headers from A1 to H1
- telephone_number
- statement_date
- account_name
- balance_from_last_bill
- current_charges
- due_date
- total_amount_due
- created_at
Click Extensions > Apps Script.
You will see a screen like this. This is a Code.gs file where we can put Apps Script codes.
Copy this Code.gs file and paste it to replace everything in your Code.gs.
Your Code.gs file will now look something like this.
Click save.
Click the dropdown then click createTrigger.
Click Run.
When prompted for Authorization required, click Review permissions.
Login to your Google account. Take note that the title of your Apps Script project will show here.
Click Advanced.
Click Go to <project-name> (unsafe).
Take note that the above is fine even if it says not verified or unsafe. It’s your apps script, so it’s fine.
Read the permissions that you will allow (might not be the same as the screenshot) before proceeding. Then click Allow.
At the bottom of the screen, wait for the execution to complete.
On the left side, click Triggers.
You should see these triggers.
If you have your previous PLDT bills in your email, they should reflect in the Google Sheet in a few seconds up to a few minutes.
Once your bill has been successfully processed, the email in gmail will have a Processed label.
The script is set up to run daily at 8 a.m. Therefore, if you receive your bill at 10 a.m., it will be reflected the next day.