Find Jobs
Hire Freelancers

Create Google App Script to Move (CUT) Row from One Sheet to Another in Same Workbook

£10-20 GBP

Completed
Posted almost 2 years ago

£10-20 GBP

Paid on delivery
I'm currently using mail parser to populate data by creating a new row in Google Sheets online (Sheet Name 'Active Leads' Columns A:S) In column D I mark the row with Data Validation (New, Active or Archive). However, I want to use this sheet only for new and active data only. When I mark row as ‘Archive’ – I would like to cut / move this row to another sheet (Archive Leads) with the same table. This means I can actively work on the data that is new and active in Active Leads sheet, and use Archive Leads for storage only. I understand that I can achieve this task through cut / paste. However, I need to remove the manual process due to a large volume of incoming data. I would like to hire you to help create google app script to automatically move row from Active sheet to Archive sheet, without leaving blank rows in Active sheet. This could be On Open sheet. (i.e. If I close the sheet and reopen the automation script happens). Please note, I cannot share or provide access to Google Drive or share document due to sensitive data and other reasons. However, I am equipped and able to install google app script with instructions. Please Comment with ***Google Sheets*** In your bid for this project so that I know you’re fully genuine and you have fully read these instructions. I am happy to discuss more over chat. Thanks,
Project ID: 33827029

About the project

9 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
£0 GBP in 3 days
4.7 (2 reviews)
2.6
2.6
9 freelancers are bidding on average £32 GBP for this job
User Avatar
Hi greetings from Tushar!! I am interested in taking up your *Google Sheets* project of moving your archive leads data from your active sheet to Archive Leads sheet . I have hands on experience of working with google app script, google sheet, APIs and google forms and have done few projects previously using google app scripts and google sheet functions and so I believe I can surely help you as well. Let's connect over chat to discuss further on this. Looking forward to hear from you. Thank you.
£25 GBP in 2 days
5.0 (14 reviews)
4.7
4.7
User Avatar
Hi, I have seen this, Albion website project and I can do this right now. I am an expert in PHP, Website Design, Graphic Design, WordPress and HTML skills and SPEED CODING WINNER. I am sure that I can do your task efficiently in less timeline and budget. Thanks
£15 GBP in 1 day
5.0 (7 reviews)
2.3
2.3
User Avatar
***Google Sheets*** I understood the requirement and i can give you the appscript for the functionality. I have good experience in google sheets app script. Thanks.
£15 GBP in 1 day
5.0 (1 review)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Ayr, United Kingdom
5.0
5
Payment method verified
Member since Jul 12, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.