Google Sheets Custom Script
Budget: $75 – $150 USD
Hi,
Note: all auto bids are ignored so if you are interested write me something specific to this project.
I am looking for someone who is experienced in Google Sheets. Here is what needs to be done.
A Google Sheet is synced with Gravity Forms and Zapier. It records service transactions.
Twice a month, an email needs to be sent to a specific person that shows certain information based on the data.
Basically, there is a column with a name of a service provider. There is another column with the total amount charged (how much the service provider made). Twice a month, we need to find all unique service provider names and calculate their totals for that time frame. For instance, we would set emails to be sent on the 15th and 30th of each month (this is example, it could also be 14th and 28th day of each month). Thus, any transactions recorded for a specific service provider for the first 15 days or so will be sent to a specific email, then another email will be sent for service provider and their total transaction value from day 16-30 of the month (or whatever we decide), and repeat. Data will always need to be reset after a period.
In order for this to be done, you will need to be able to list all unique service providers that made any money during the specific time frame by their name and add up their total transaction values. Thus, you must be able to group service providers with the same name. Alternatively, we could create a list of all possible service providers but this could update frequently.
The email sent will basically be formatted with the timeframe, name of the service provider, number of tasks completed (basically how many rows attributed to them) and the total amount they made during the specific time frame. This would be sent to 2 or 3 e-mails utilizing Google Sheets gmail integration or other.
Note: all auto bids are ignored so if you are interested write me something specific to this project.
I am looking for someone who is experienced in Google Sheets. Here is what needs to be done.
A Google Sheet is synced with Gravity Forms and Zapier. It records service transactions.
Twice a month, an email needs to be sent to a specific person that shows certain information based on the data.
Basically, there is a column with a name of a service provider. There is another column with the total amount charged (how much the service provider made). Twice a month, we need to find all unique service provider names and calculate their totals for that time frame. For instance, we would set emails to be sent on the 15th and 30th of each month (this is example, it could also be 14th and 28th day of each month). Thus, any transactions recorded for a specific service provider for the first 15 days or so will be sent to a specific email, then another email will be sent for service provider and their total transaction value from day 16-30 of the month (or whatever we decide), and repeat. Data will always need to be reset after a period.
In order for this to be done, you will need to be able to list all unique service providers that made any money during the specific time frame by their name and add up their total transaction values. Thus, you must be able to group service providers with the same name. Alternatively, we could create a list of all possible service providers but this could update frequently.
The email sent will basically be formatted with the timeframe, name of the service provider, number of tasks completed (basically how many rows attributed to them) and the total amount they made during the specific time frame. This would be sent to 2 or 3 e-mails utilizing Google Sheets gmail integration or other.