I am building a portal site on classic cars
We need to create a master file of different databases/lead generation projects for our newsletter campaign. This means to combine several excel sheets into one, filtering for any duplicates in names / emails and removing any unnecessary data (keep: Name, Surname, email and phone number).
...have few google sheet files that require some data manipulation such as deleting some columns and rows, filtering and sorting, add some charts and perhaps add data from multiple sheets into one. It is also possible to do a Macro to apply the same manipulation into an Excel spreadsheet, I will just download it from google as excel format and use ...
Need help for copying german handwritten paper sheets into a textfile. Samplefile is attached.
Hi there Looking for someone to implement some zaps for us using the below triggers: 1. Gmail - new label added 2. Create spreadsheet row (populate name and email address) We need this done for 4x tags across 3-4 email accounts, feeding into a single, tabbed Google Sheet. Happy to chat through / explain further. Leigh
I am trying to do two tasks on a Google Sheet I have. The tasks I would like done are to link 1 Sheet, called Order Summary which needs to be sorted by customer names. There is 1 sheet called Customers with 4 columns. As these columns are updated, I want the sheet Order Summary to update. I also would like 1 script added to sheet Order Sum...
I'm a poker player and have around 100 ranges that I would like across bet sizing grids vs positions. There is a video attached that shows the idea exactly. The grid size on each sheet will vary, but each cell of the grids will link to pictures of ranges across the grids bet sizes. At the bottom of the excel video you'll see there are 6 sheets with
Hi there, I am looking for an expert with Google Sheets. It is about automatic web scrapping from different websites into Google Sheets. Script needs to fetch data every few hours automatically. NO PYTHON - I want everything to happen in Google Sheets (G Suite-Plattform). PRICE - MAX. 30EUR
I'm looking for someone who is expert on google sheets to make graph and statistics
...I have a project which requires someone with skill in HTML. I want to send an automatic email to my customers, which will have this star rating. [login to view URL] I want my system (Netsuite) to be able to put the customer's order number and name and email address into the HTML of the star rating, and send an email to the customer
...this is only done once a new employee starts or new projects get releasedWe input data into the RWN DEAL PROGRESSION – Master file on a daily basis with a row per [login to view URL] data is automatically added to the RWN ACCOUNTS file (the main file! From which all others get their data)In the RWN CLIENT CARE – Master file dates are added to...
Current Google sheet: [login to view URL] Functions imports events from google calendar and parses the data into time sheets, then calculates distances from addresses. Here is a sample calendar with test events in December 2017 and January 2018. The sheet is linked
...would like to learn more about how to use APIs in Google Sheets. I would like to create a Google Sheets document that pulls from multiple API sources, but I don't know how to set this up or set up the connection to these APIs. I'm looking for someone to show me how to...
i have a google sheet file/scripts that are currently quite buggy. i want to create a modification that should eliminate all bugs by changing the way the user interacts with the script notes: 1. currently there is a script called goLockloop that is triggered whenever the submit button at the bottom of the page is edited to a "yes&...
I want to pull data in from [login to view URL] and other sites, and rearrange the data with auto-updating where it will store the data. I am looking to make graphs and charts. I am looking to have
Hi, I have 7 spec sheets in English for a salmon company which I need translated into Italian ASAP - much of the information in them is the same so it should not take too long. They are technical, but easy to understand.
I have a client server business application which is basically an accounting, sales, purchasing and inventory control package. I need to create a Qlikview dashboard with multiple sheets. One to give overview of company performance, one for sales and customer performance, one for suppliers and their performance and finally one for product performance
Google sheets script to send email and pdf attachment. The pdf name will be referenced on a google sheet. the drive is static. only email where cell C = N
I have two spreadsheets on the same google drive account. "Spreadsheet A" contains my shop orders, one order per row. Sometimes I will edit manually some of the cells for each order. I need a google apps script that automatically copies all the modifications on 4 columns of the "spreadsheet A" and apply the same modifications on "...
Hi I need the following formula. We use Google sheets for tracking projects. We need to be able to know when we have assigend a person too many tasks for them to complete in one day. So if we assign them too many hours, something goes red to highlight it. Here is a sample spreadsheet: [login to view URL]
We need to enhance our current Excel sheets to export information into accounting software, ComputerEase. This project is for a small construction company suing budget/estimating sheets, time/materials sheets, ect.
...certain formulas made to highlight key points of Data. I have attached 2 example images so you can have more of a visual explanation of what I need done. I will have further work needed, however they will require some more advanced skills, so any proof of past work will be appreciated. If you cannot show me past work that is relevant to what I need, then
Hello, I have a task I need help with... I need you to go into this app called "PepTalks" and in the beginning before signing up the app will prompt you with a screen with quotes. I need you to write down all the quotes (or 100 at least) into a google sheet document. Grammar must be impeccable. All punctuation marks must be present, inc...
Hi - I run my own small business in the dairy markets. Part of what I do is provide fundamental analysis to my customers, including updates on changes in import/export/production data. This involves taking data from various government sources (e.g. USDA, Eurostat), getting the data into Excel and then updating a variety of worksheets/charts from there
All requirements are to be built in Google Sheets 1) (Tab 1) Extract global top 500,000 followed streamers. The top is based on the highest following. 2) (Tab 2) Extract European top 500,000 followed streamers. The top is based on the highest following. 3) (Tab 3) Extract UK top 500,000 followed streamers. The top is based on the highest following
I’m looking for a developer to pull slack user data from the Slack API into a google sheet. It would be google script code that users the slack user api that will fetch info such as name, email, time zone, if they are active and then have it populate a google sheet. This is done with a couple slack Rest API calls!
I just need a simple Google Sheets script to copy the entire last row and paste it down one row below. This script will be run once a day to keep copying down the last row for each new date. I can get this scrip to work in Excel but not Google Sheets:
I want to store some data to one of my google sheets in google drive. As these codes will be deployed in my google cloud VM, no web authentication is allowed. Please use python 2.7 to finish this job. Easy job and good payment.
I need a tool which should have following features. - filters the emails received on Gmail. - Parse required text only from each email. - Paste the text into the google sheets into the related cells. - An example can be provided on request.
I need develop an google sheet that imports and shows time attendance data from an fingerprint device ( from brand zkteko )
We have a google sheet used for a business. It has multiple formulas and scripts that automate most of the business processes. We need someone to make some changes and improvements on it as the original creator is not available.
We are keen to find basic level data entry candidate to copy email domains from a Google Sheet into our order management software, Linnworks. Ideally, this should be done within a two week period as there are around 18000 to input.
Script>Editable>Google Forms>Google Sheets The form will add values in the form of titles to the sheet. The part I need help with is a cross-referencing script that will input values from the form into a sheet as hyperlink values instead of plain text. So I think I need a script (using a sheet) that cross...
Hello - I have a simple contest for Excel Masters for a spreadsheet: Period Flow thru Worksheet: Criteria 1: Column I “Actual”: Match (sumifs) column C with “Sales Tab” column b “restaurant_id” Criteria 2: sales tab “business date” (column C) with calendar tab “date” (column A) Criteria 3: Period Flow Thru W...
I need you to develop some software for me. I would like this software to be developed for Windows using .NET.