Write Google App Script functions
Budget: £20 – £250 GBP
I'm looking for an experienced App Script developer to write some basic functions. The purpose is to help automate some of the tasks I currently do manually (e.g importing data) and to also enrich the rows once imported, using some simple requests to external APIs.
I've already built some parts of this functionality and have knowledge of what's required. Please provide your price based on the description below (must be delivered this weekend).
Function 1: Import JSON file(s) from URL
- Fetch JSON files from external URL
- Parse JSON data and insert into specified Sheet
- Run de-duplication function against imported data using specified column
Function 2: Generate POST requests (Type 1)
- Fetch all rows from specified Sheet where jobId column is empty (which tells us the row is not yet processed)
- For each row where videoUrl has a value, generate POST request (fixed request, simply add videoUrl for each)
- Handle the response to each request, add the jobId and mediaUrl given in the response to the same row
Function 3: Generate POST request (Type 2)
- Fetch all rows from specified sheet where mediaUrl exists (this would be added by Function 2)
- For each row, generate POST request (fixed request, simply add mediaUrl for each)
- Handle the response to each request, add values from JSON to the same row
Function 4: Move data between Sheets (Type 1)
- Copy data from one sheet to another (mapping data from source sheet into the destination sheet)
- Once row has been processed, add timestamp and status into the source row to denote its been processed
I've already built some parts of this functionality and have knowledge of what's required. Please provide your price based on the description below (must be delivered this weekend).
Function 1: Import JSON file(s) from URL
- Fetch JSON files from external URL
- Parse JSON data and insert into specified Sheet
- Run de-duplication function against imported data using specified column
Function 2: Generate POST requests (Type 1)
- Fetch all rows from specified Sheet where jobId column is empty (which tells us the row is not yet processed)
- For each row where videoUrl has a value, generate POST request (fixed request, simply add videoUrl for each)
- Handle the response to each request, add the jobId and mediaUrl given in the response to the same row
Function 3: Generate POST request (Type 2)
- Fetch all rows from specified sheet where mediaUrl exists (this would be added by Function 2)
- For each row, generate POST request (fixed request, simply add mediaUrl for each)
- Handle the response to each request, add values from JSON to the same row
Function 4: Move data between Sheets (Type 1)
- Copy data from one sheet to another (mapping data from source sheet into the destination sheet)
- Once row has been processed, add timestamp and status into the source row to denote its been processed