|Google script to filter JSON array based on GET/POST parameter sent to google script
||I have google spreadsheet and google script that transforms google spreadsheet data into JSON. I need to:
* send parameter to script page
* sort array based on parameter sent
*present page with sorted JSON data.
The part of code transforming google sheet to JSON is working, i can provide tutorial and code example.
||Apr 21, 2018
|Twiter API Google Scripts and Google Sheets
||Our current script needs to be corrected real quick. Most of the code has been written and need a quick fix.
Overview: We have a script that will connect to Twitter API (authentication provided by client) but need corrections, and retrieve tweets for a user via URL defined in spreadsheet. Scope: - Create a trigger with a button, menu item or cell change that will execute the remote API call to...
||Apr 20, 2018
||Apr 20, 20185h 1j
|Develop Facebook Group Crawler Script or Chrome Extn
||Looking for a chrome extn or script.
The script must have 2 function:
1) Setup some keyword, and Send an email alert to person when new post with selected keyword is posted in facebook group. The email must contain:
- Text of the post
- Link to the post
2) Search inside private Facebook group all the post with some keyword inside the posts (not the comment). Download the post and all the ...
||Apr 20, 2018
||Apr 20, 20185h
|Google Sheet Script Code Fix.
||Hi, I have google script that add row to another sheet when cell changes.
But I need script that add row to another spreadsheet(not another sheet).
If you are expert, you can do it less than one hour.
The work will be done via teamviewer.
If you can do this job, Feel free to bid.
||Apr 19, 2018
||Apr 19, 20183h 17j
||I have a Google Sheet document with 3 tabs. See following link. [URL dibuang, sila log masuk untuk melihat] I'd like to create a script to: 1. Copy the cell values only from A2 from " Filter" spreadsheet and paste into cell C8 from "Valuation" spreadsheet, activating "Valuation" sheet functions to do calculations (this takes some time) 2. Copy output values only ...
||Apr 8, 2018
||Apr 8, 2018Tamat
|Develop Existing Programme - Java Script sending email alerts based on Google Spreadsheet data
||We currently have a Java program which runs on our computer on a daily basis. It scans a Google Spreadsheet and will send out email alerts if certain information is still required from our customers.
For example if field A1 still says REQUIRED on a certain date displayed in B1 then an email will be sent.
The existing system is has been created by a previous freelancer and we have the files...
||Apr 8, 2018
||Apr 8, 2018Tamat
|quick edit to ahk (autohotkey) script
||I need a quick edit to my ahk (autohotkey) script, to go back to 1st row of google sheet. Currently stays stuck on last row of spreadsheet.
||Apr 4, 2018
||Apr 4, 2018Tamat
|Create script in Google Spreadsheet that will trigger invoice in accounting system
||Hello, would like to support with setting up a script in Google Spreadsheet that will trigger invoice in accounting system.
The process should work as follow:
1. Data (Organization name, organisation postal adress, Items, Costs etc) is inputted in a Google Spreadsheet
2. A Google spreadsheet script is triggered (e.g. by clicking on a button)
3. The script is connecting through OAuth 2.0 to...
||Mar 27, 2018
||Mar 27, 2018Tamat
|Google spreadsheet macro
||I want a small script in my google spreadsheet.
||Mar 21, 2018
||Mar 21, 2018Tamat
|Udemy Course and Lecture Description Writing after research
||I have 4 courses on Udemy and it will keep on growing. I want some one who can study, on other course, how the descriptions are written and write descriptions and other details about my course. Some one with interest or knowledge of Google Spreadsheet is a big PLUS. I will give free access to courses, so you will also be able to learn abut Google Spreadsheet and Google Apps Script. Writing should ...
||Penulisan Iklan, Penyelidikan, Article Writing, Penulisan Kandungan
||Mar 18, 2018
||Mar 18, 2018Tamat
|Update a Google Spreadsheet / Calendar Script
||We have a Google script that is suppose to create new Google Calendar events based on information on a Google Spreadsheet (see attached). The script no longer works with Google Calendar, so it needs to be updated. More specifically, it appears that the script executes properly, but Google Calendar only creates the first event (//create event on 5 years) and ignores the other events (for example, /...
||Mar 18, 2018
||Mar 18, 2018Tamat
|Simple Copy Google Sheets API Script
||Im struggling to create a simple script.
I have a web form that automatically populates a google spreadsheet. I need to copy the new rows as they come in, into a different spreadsheet in the same google drive.
Source Spreadsheet File: 1TGjLXrMrCb5crfcQvwsc5vPWQEy8af-ZkPNon1POYjE
Source Sheet: Sheet1
Range of Data in Row is Column G:V (Row 3 onwards) (Additional cell AX on same row)
||Mar 12, 2018
||Mar 12, 2018Tamat
|Google script expert needed
||I need a google script expert to automatically generate and save an unique ID to the google spreadsheet connected to a google form
||Mar 6, 2018
||Mar 6, 2018Tamat
|Write a script on Google Spreadsheet to import data from a external tool by using an API
||We want to import automatically the data from LiveChatInc into a Google SpreadSheet. We use an API, more information here: [URL dibuang, sila log masuk untuk melihat]
The goal is to write the relevant script on Google SpreadSheet to import the data on a regular basis.
||Mar 1, 2018
||Mar 1, 2018Tamat
|Script for repeated automated data import
||I need a script that imports data at the end of each day (23:59 central european time) and puts it into a spreadsheet. This can be Excel or Google Spreadsheet (Each day into a new sheet). The source of the data can be found here: [URL dibuang, sila log masuk untuk melihat]
The page behaves a bit special, because once it is past midnight, the page for the new day sets up and there is no archive fu...
||Feb 27, 2018
||Feb 27, 2018Tamat
|grab NASDAQ real-time stock quotes in Google Spreasdsheet or Excel
||I need a script that grabs real-time quotes of stocks NVidia and Amazon (quoted on Nasdaq) into Google Spreadsheet or Excel.
I don't know any sources for these data so as requirement I also need you to know a source for them, free of charge or under $50/month (for 2 stocks).
I need the data of at least the last 3 years with at least 1hour resolution.
Please specify the resolution and c...
||Pemprosesan Data, Excel, Pengikisan Web
||Feb 21, 2018
||Feb 21, 2018Tamat
|google places api expert
||Develop a WebCrawler script for Google Places Api which is capable of doing the following tasks using my google api key:
1. take input a spreadsheet which have columns:
Merge in a input string with everything not empty (1), (2), (3), (4), (5). Make the queries to the google place autocomplete and google details.
2. return output t...
||Python, Pengikisan Web, API Peta Google
||Feb 19, 2018
||Feb 19, 2018Tamat
|Google Apps Script - External API to Sheets
||I need a Google Apps Script that reads out the data from this API into a google sheets spreadsheet:
[URL dibuang, sila log masuk untuk melihat]
The API is well documented there. The authentication used by the API needs to be send in the HTML header and incl. a nonce which must by dynamic (timebased).
This is the data call I need:
And this is the data I want in my google spr...
||Enjin App Google
||Feb 10, 2018
||Feb 10, 2018Tamat
|Google docs Spreadsheet - Skype click 2 call script
We are using google sheets for cold calls and need to find a way to use the Skype click to call function.
We need someone to write a small script in google sheets where we should be able to click on a number and be dialed directly with our Skype program. Somehow be able to use the Skype URIs with the hyperlink function in the sheets.
We tried the skype click to call browsers extens...
||Memasang Skrip, Enjin App Google
||Feb 8, 2018
||Feb 8, 2018Tamat
|Need a google spreadsheet script to import from a csv via API
||An owner of a site provided me with API access to their data. Their instruction is as follows:
Basic query address: [URL dibuang, sila log masuk untuk melihat]
Query example: [URL dibuang, sila log masuk untuk melihat]
(I will give you the actual thing of course).
So I currently use it to downlo...
||Memasang Skrip, Excel, Pengaturcaraan , Scripting, API
||Feb 6, 2018
||Feb 6, 2018Tamat