Google Sheets Data Extraction Automation

You have your data scattered around in different sheets and want to put all of them in 1 place?

We can help you automate that task using Google Apps Script!

This Script can:

1. Recursively look into a folder
2. Process all files whose names end with "(NEW)"
3. Extracting data from a Sheet named "Payment entry".
4. Only process files that has data
5. Cleaned destination and pasted to the second row onwards (Headers can be modified)

HOW TO USE:

1. Open your destination Google Sheets file.
2. Navigate to Extensions > Apps Script
3. Paste the code into the Editor
4. Copy your Drive Folder ID (You can find it in the URL of your Drive folder) and paste into the folderId function.
5. Copy your Destination ID (You can find it in the URL of your Google Sheets file) and paste into the destinationFile function.
6. Ctrl + F to find 29, change it to the number of columns you want to pull data. Change 29 to 3 if Col A -> Col C.
7. Specify the name of the sheet you want to pull data from, change it in line 45
8. If you want to pull data only from Spreadsheets whose names end with certain words, change line 34