Suoritettu

Google Apps Script to place the information of many sheets in a file in a single sheet

I need a Google Apps script that does the following:

- Take a Google Sheets single file that has over 300 sheets (each sheet with the same columns).

- Put each row of information in each sheet in a new file.

- The new Google Sheets file will contain all the rows in each sheet of the original file but in one single sheet.

- The original information will be "stacked up".

- Add a new column that contains the name of the sheet each row in the new file originally belonged to.

Feel free to ask any questions.

Payment through freelancer only.

Thanks in advance,

Taidot: JavaScript, Google Sheets, Google App Engine

Näytä lisää: html file script add information text file, google apps engine file upload, ics file work google apps, write script migrate cyrus google apps, google apps script for sheets, i am looking for someone to write a google apps script in google sheets, script src http pastebin com embedjs php i 9bc6wngf script, google apps script open file in new tab, google apps script read file, google apps script share file, google apps script create text file, python file open do i need to close, google apps script config file, google apps script sheets, google apps script search file in folder, how to merge excel sheets into single sheet, copy all data from multiple sheets to single sheet, google apps script form file upload, google sheets export single sheet, google apps script open file

Tietoa työnantajasta:
( 13 arvostelua ) Cuauhtemoc, Mexico

Projektin tunnus: #31874655

Myönnetty käyttäjälle:

IgeS

Hi there, Need an apps script that combines all Sheets in a Spreadsheets into a single sheet? Please see my proposed script in my video demo on the link below and message me if that is what you need? I'll be standi Lisää

$25 USD 1 päivässä
(7 Arvostelua)
3.3

7 freelanceria on tarjonnut keskimäärin $35 tähän työhön

mindprogram

Hi If you need just the final final with all the data and sheet number column, I can do this better in PHP. The PHP script will take data from Google Sheets via API and then upload the final file back to wherever need Lisää

$40 USD 2 päivässä
(55 arvostelua)
6.3
(21 arvostelua)
4.7
(4 arvostelua)
4.2
josanta

Hello there, I have read and understood what you want I can combine them the way you have described above. This will not take long. Can we talk Thanks!

$50 USD 1 päivässä
(7 arvostelua)
3.4
MitchellsWork

Hi there, Grabbing rows from all sheets and stacking them in a single sheet will not take long. As an experienced Javacript developer & having worked with Google Apps Script / Google Sheets, I can surely make this hap Lisää

$25 USD 2 päivässä
(0 arvostelua)
0.0
jmc673sm

Hello! I can do this for you (stack the info from over 300 sheets into a single sheet) in just a couple hours from the time I start the task. I'm a professional software/database developer with over 25 years experience Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0