Republic Service Gmail Feeder Applicaton

Republic Service for Garbage - Data Feeder via Gmail

• This application covers the properties in both City of Stockton and Las Vegas

• Data Model:

  • Gmail Query => parseRepublicServiceEmails.gs

    • => Republic Service GMail Feeder GDS => RepublicGmail sheet

  • Gmail Transformer => transformRepublicServiceEmail.gs

    • => Republic Service GMail Feeder GDS => RepublicTransformed sheet

  • Import Transformed data => Manual 

    • Republic Services Utilities GDS => Yearly Sheet

    • Insert to this sheet on the top

    • Notice that the SortRepublic sheet is imported to this sheet as well up to Oct 2023

  • Aggregate Republic Transformed data

    • => AggregateUtils GDS => UtilsYear

    • This is automated via ImportRange() function

  • end