Closed

Google Apps (G Suite) script

I need a google sheets script that makes the following for every existing record in a spreadsheet:

1) Takes a set of columns as inputs in the Original Sheet (Let's say we have A1= 65, B1= 1.65, C1= John, A2= 85, B2= 1.83, C2=Michael, etc. )

2) These inputs are copied into different cells in another Sheet where there is sequence of static calculations that throw one or more outputs. These calculations can't be moved, edited, neither make the formula expanded into other cells... they just take a fixed input list, and throw a fixed output(s) result. (ie. in another sheet the inputs need to be copied in S100:S101, and the output (4 outputs) is calculated in Z7:Z10.

3) These 4 outputs are now added in the next columns of the original Sheet for every according record. (For John, it would be in D1:G1... and for Michael it would be in D2:G2, and so on)

Extra (to be discussed / negotiated):

- Can we add the result of URL's containing web forms also? (As an example URL1 a BMI Calculator like [url removed, login to view], and URL2 a Weight on the Moon Calculator like [url removed, login to view])

- The according outputs of each Calculator would be added in the next available columns (H1= result1_for_John, I1= result2_for_John, H2=result1_for_Michael, I2= result2_for_Michael, etc.)

Example:

[url removed, login to view]

Skills: Excel, HTML, Javascript, PHP, Web Scraping

See more: i am looking for someone to write a google apps script in google sheets, google apps script, google apps script for sheets, google apps script attachments forward, google apps script api, google apps script validation, php script google apps sso, google apps script email validation, email validation google apps script, google apps script smtp, google apps script email verification, sso script google apps, write script migrate cyrus google apps, dolphin web portal google apps, spf record google apps web forms

About the Employer:
( 0 reviews ) Mexico

Project ID: #16168574

14 freelancers are bidding on average $1908 for this job

hiramalik321

Hi there, I've read your project description and I am confident enough that I can handle this project according to your expectations. I have done similar projects before and I want to take over this project as well. If More

$3100 MXN in 5 days
(46 Reviews)
6.4
archanaoswal

I have excellent command on Google Sheets and have done similar tasks before. Few of my past projects: - Upload and Manage Videos in Vimeo using JSON API in google sheets - Extract mails and attachments from gmai More

$2000 MXN in 2 days
(47 Reviews)
5.5
shingjin

Hello. Checking your post, i am interested in that. As a result-driven person, i can help you and open to work. If you are looking forward the good candidate, pls contact me. Let's built your project successfull More

$2000 MXN in 5 days
(22 Reviews)
4.9
mohamedkaram93

Hi there, I will be happy to help you with that. We can create a Google Script that will create a custom menu near the Help menu. When you click that menu, it will copy the data in the first three columns A, B and C More

$1666 MXN in 2 days
(25 Reviews)
4.8
shahidabro8

PHP, HTML5, CSS3, WordPress, Shopify, Magneto, Bootstrap, E-Commerce, CodeIgniter, Website Design, OpenCart, Woo- Commerce, J2EE, Java, JavaScript, jQuery, JSON, Android Application Development, IOS Application Develop More

$2333 MXN in 3 days
(22 Reviews)
3.6
yyer

I have done several projects with GSuite (Spreadsheets, Calendar, Form, etc.). This skills are "mainstream" in my freelance activity. I would like to improve them and achive high quality in every project.

$1666 MXN in 5 days
(10 Reviews)
3.0
andreird129

Hello How do you do? I am excel expert. I think i can do it. i will do my best for your project. I want to work with you.

$674 MXN in 3 days
(3 Reviews)
1.7
sidmish

As you would have checked my profile, yes im new to freelancer. But currently im heavily working on google apps script on daily basis. I have created many web app as well and also made a app using advance services. You More

$2555 MXN in 2 days
(1 Review)
0.8
israth2

Hello, I have read the description of the project and I am interested in working on this project. Please send a message so that we can discuss the project exclusively.

$2333 MXN in 3 days
(0 Reviews)
0.0
JAYBIRHADE

My Software Skills are: Microsoft Office(Word, PPT,Publisher)Corel Draw, Adobe InDesign, PDF, After Effect Animation, Adobe Photoshop, Adobe Illustrator, EXPLAINER VIDEOS,Nitro PDF. My Expert Skills are: LOGO, More

$2333 MXN in 3 days
(0 Reviews)
0.0
mukeshjap

Hi ! As I have seen your above explained requirements for yours projects. Hello There, Greetings for the day ! Our technical expertise includes cross-platform proficiency (Windows, Unix, Linux and VxWorks); More

$500 MXN in 3 days
(0 Reviews)
0.0
SMAyub2112

We are a team of computer Professions/expert. We have a lot of experience of similar types of job. We are available all the 24 hours and we are dedicated to hard work, accuracy and punctuality.

$1000 MXN in 3 days
(0 Reviews)
0.0
$2333 MXN in 3 days
(1 Review)
0.0
SaadAhmad87

i have already developed excel based sheet to fetch web data forms for further working, we can have chat or contact through email

$2222 MXN in 3 days
(0 Reviews)
0.0