I Have Created A Make Scenario In Which The Google Sheets Data Is Added On To The Monday Board. And If An Item Already Exists The Module Updates The Item In Monday.com. If The Item Does Not Exist On Monday.com It Creates The Item On The Board. I Want To Add A Feature Where Monday Board Only Shows The Data That Is On Google Sheets And Auto Deletes The Data That Is Old And Not Present In The Sheets
I Want To Add A Module That Deletes Data From The Board If It Is Not Present In The Sheets.
Hi @Stallone_Fernandes
You can run another scenario to delete
Sample workflow:
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
Hi Msquare_Automation,
Thanks For Reaching Out. I Want To Set It Up In Such A Manner That Only The Data That Is Not Present On Sheets Should Be Deleted Rest Other Data Should Be Kept Untouched. Is This Possible With The Solution You Have Provided ?
We apologize for the confusion. You need to setup the workflow in this way:
This will be one time run workflow.
P.S - this will cost double operations of number of records in google sheet.
Best regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
I Am Quite New To Using Make.com For Automation Can You Help Me Out With A Screenshot Of The Scenario Replicating My Current Scenario ? This Would Be Really Helpful.
Please try this blueprint:
blueprint (74).json (79.6 KB)
P.S: While using map() function, hover over the variables you want to map to get their raw names.
Best regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
@Stallone_Fernandes
We have created a detailed loom to explain the procedure.
Please follow this loom for detailed explanation
And import the attached blueprint in your scenario to use.
blueprint (75).json (102.1 KB)
Best regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Can You Go Through My Scenario And Check And See If Everything Is Fine Because The Delete Function Is Still Not Functional. Also I Am Facing An Issue With Update. The Scenario Is Just Creating Items And Not Updating It Neither Deleting Pre Existing Data That Is Present On Monday Board. I Tried To Replicate Every Step As Shown In The Loom Video. Please HELP !
Please share the blueprint of your scenario.
Best regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Sure Thing
blueprint (1).json (119.6 KB)
Also Please Take A Note That Some Values That Are Duplicates On The Google Sheets Have To Be Added To The Monday Board. I Am Unable To Get The Duplicates To The Board As Only 1 Of Them Is Able To Be Populated To The Board.
You were using map() function in wrong way. We have corrected for you. Please import this and and then map the column values in Monday create or update item module.
e consider container id from google sheet is the item name in Monday. If that is different then change with the column that has same value as container id.
If this doesn’t help you either. We advice you to reach out to us live.
Best regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
I Have Not Yet Received The Corrected Blueprint Please Share The Corrected Blueprint So I Can Check And Make Changes @Msquare_Automation
Made Changes To The Filter Map Function By Adding ROW_NUMBER But Still Does Not Work. Please Share The Blueprint.
I’m Sticking To My Initial Blueprint.
blueprint.json (99.6 KB)
I Just Need A Few Suggestions On Changing The Filter Type.
Problem Statement:
