Google Sheets Ordering Form Automation
Budget: $10 – $30 AUD
I have a Google Sheet which contains a list of Brands, Product and categories along with their retail prices.
What i would like to do is created a script in it to automate the creation of clone ordering sheets for customers to order from on google sheet docs.
What i historically did was send read only access to everyone and then for my key customers, I create 10x or 15x copies of this sheet every time and send a seperate one to each of my customers who then login with their gmail address and update their order quantities on the sheet itself.
The reason why it is separate copies is obviously is because I cannot have customer X see what Customer Z is ordering on the sheet itself (column J)
Once the client completes the order, they let me know and I go in and trigger an internal notification for the fulfilment team to process the order in the warehouse.
There is a manual component in this process and the most time consuming one. Sometimes the price of a product changes or the inventory gets sold out. Sometimes there is a brand that should only be available for customer X and not customer Y.
What I would like to do is:
1. Create 1 master sheet which then automatically creates copies of this sheet and automatically updates prices on all the google sheet copies that I create from it. (I can do that by cell mapping the master sheet to alt the different copies, but I could perhaps have a script that does it. -Make sure that all new sheets created for customers are still mapped back to the original cells fro the master sheet
2. Have 1 column that contains a hyperlink which shows an external snippet of the image of the product on the website once updated. (You could use AI to have that transposed into the sheet from a script that pulls the images directly from the website)
3. Have the ability to add an extra column for each customer under column K,L,M for example ( Example: K associated with customer X and L associated with customer Z) then map each of the 150 rows with a yes/no cell. If I enable “yes” for row 10 and disable “no” for row 12, the customer X will see automatically from the master sheet in a seperate sheet product under row 10 and will not see the product row 12
Each column I add - will create automatically a new copy for the client to go in and put their order on it. Along with the visible/invisible rows associated with a brand/variant.
The aim is to automate changes, updates and the visibility for each customer from 1 master sheet is instead of having to manually change each row and sheet 10x times every time for customers
Data Sources:
- Utilize Google Sheets and Emails as input data sources for the automated workflows.
Ideal Skills:
- Proficiency in Make.com and Google AI.
- Experience in creating automated workflows.
- Familiarity with Google Sheets and Google Doc ordering forms.
- Google AI Agents
I look forward to receiving your bids.
What i would like to do is created a script in it to automate the creation of clone ordering sheets for customers to order from on google sheet docs.
What i historically did was send read only access to everyone and then for my key customers, I create 10x or 15x copies of this sheet every time and send a seperate one to each of my customers who then login with their gmail address and update their order quantities on the sheet itself.
The reason why it is separate copies is obviously is because I cannot have customer X see what Customer Z is ordering on the sheet itself (column J)
Once the client completes the order, they let me know and I go in and trigger an internal notification for the fulfilment team to process the order in the warehouse.
There is a manual component in this process and the most time consuming one. Sometimes the price of a product changes or the inventory gets sold out. Sometimes there is a brand that should only be available for customer X and not customer Y.
What I would like to do is:
1. Create 1 master sheet which then automatically creates copies of this sheet and automatically updates prices on all the google sheet copies that I create from it. (I can do that by cell mapping the master sheet to alt the different copies, but I could perhaps have a script that does it. -Make sure that all new sheets created for customers are still mapped back to the original cells fro the master sheet
2. Have 1 column that contains a hyperlink which shows an external snippet of the image of the product on the website once updated. (You could use AI to have that transposed into the sheet from a script that pulls the images directly from the website)
3. Have the ability to add an extra column for each customer under column K,L,M for example ( Example: K associated with customer X and L associated with customer Z) then map each of the 150 rows with a yes/no cell. If I enable “yes” for row 10 and disable “no” for row 12, the customer X will see automatically from the master sheet in a seperate sheet product under row 10 and will not see the product row 12
Each column I add - will create automatically a new copy for the client to go in and put their order on it. Along with the visible/invisible rows associated with a brand/variant.
The aim is to automate changes, updates and the visibility for each customer from 1 master sheet is instead of having to manually change each row and sheet 10x times every time for customers
Data Sources:
- Utilize Google Sheets and Emails as input data sources for the automated workflows.
Ideal Skills:
- Proficiency in Make.com and Google AI.
- Experience in creating automated workflows.
- Familiarity with Google Sheets and Google Doc ordering forms.
- Google AI Agents
I look forward to receiving your bids.