Monitoring of Meralco Bill in Google Sheets

This will work, provided you are receiving your Meralco 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 F1

• bill
• account
• period
• amount_due
• due_date
• 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 this trigger.

Now, you wait for your next email of Meralco bill and the Google Sheet should be updated with new details that look like this.

Once your bill has been successfully processed, the email in gmail will have a label Processed.