Google Sheets Scripting
- or -
Post a project like this2267
£10(approx. $13)
- Posted:
- Proposals: 3
- Remote
- #1876995
- Awarded
Description
Experience Level: Entry
General information for the business: N/A
Description of requirements/functionality: I am using Zapier to populate a spreadsheet based on emails received.
This information is then emailed out using a different Zap.
In between emails, I am using formulas in the Google Sheets to calculate a response date / time based on the time and date of the original email. There are no issues with the formula calculation, but the email is triggered when the data is populated into the next *empty* row on the sheet. This means that I cannot have pre-populated formulas on the sheet. It will be looking at around 200 emails a day meaning this cannot be done manually. I am looking for a solution (possibly a script) to insert the formula into specific columns once the Zap has added the first half of the data but not before to ensure the row remains empty.
Any questions or more information required, please do ask.
Specific technologies required: Google Sheets, Zapier
Extra notes:
Description of requirements/functionality: I am using Zapier to populate a spreadsheet based on emails received.
This information is then emailed out using a different Zap.
In between emails, I am using formulas in the Google Sheets to calculate a response date / time based on the time and date of the original email. There are no issues with the formula calculation, but the email is triggered when the data is populated into the next *empty* row on the sheet. This means that I cannot have pre-populated formulas on the sheet. It will be looking at around 200 emails a day meaning this cannot be done manually. I am looking for a solution (possibly a script) to insert the formula into specific columns once the Zap has added the first half of the data but not before to ensure the row remains empty.
Any questions or more information required, please do ask.
Specific technologies required: Google Sheets, Zapier
Extra notes:
Nicholas P.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
8 Feb 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies