Build me a merging tool for google sheets
Budget: ₹1,500 – ₹12,500 INR
I want to pull data from one google sheet and add data to other sheet based on values in the cell.
We are one coaching institute where typically students pay the fees in 2-3 installments. Currently when a student takes admission he pays some token amount and later clears the fees in multiple installments. This data is entered by sales team. However we keep a separate dues tracker and students list. Now we want an automation tool which can merge the data collected from sales team to dues tracker.
Input data sheet - given by sales team (Hence referred as sheet 1)
Output data sheet - Overall dues tracker and admission sheet. Same sheet is used here. (Hence referred as sheet 2)
Logic to be followed for merger -
1. Is it a dues clearance? If Yes then search for the (mobile number and batch) of the student in sheet 2 and update the values against that row
2. Is it a new admission? If yes then make a new entry
We are one coaching institute where typically students pay the fees in 2-3 installments. Currently when a student takes admission he pays some token amount and later clears the fees in multiple installments. This data is entered by sales team. However we keep a separate dues tracker and students list. Now we want an automation tool which can merge the data collected from sales team to dues tracker.
Input data sheet - given by sales team (Hence referred as sheet 1)
Output data sheet - Overall dues tracker and admission sheet. Same sheet is used here. (Hence referred as sheet 2)
Logic to be followed for merger -
1. Is it a dues clearance? If Yes then search for the (mobile number and batch) of the student in sheet 2 and update the values against that row
2. Is it a new admission? If yes then make a new entry