So,
I use Google Sheets to manage my company's data. I have around 10+ spreadsheets with multiple worksheets connected internally via Pabbly (Thanks to the founders of Pabbly, I cannot imagine my life without it!!). But, whenever I come across a need of adding a field (column), I grind my teeth knowing I will have to open all the automations, cruise through it to the Action Step referring to the sheet I had added a new field and referesh it and save it. Now this can be done when you are dealing with a few sheets and a few workflows. But as I said, I use 10+ spreadsheets and over 25+ workflows.
Hence, I would like to know if there is a easy way to do the above action.
I use Google Sheets to manage my company's data. I have around 10+ spreadsheets with multiple worksheets connected internally via Pabbly (Thanks to the founders of Pabbly, I cannot imagine my life without it!!). But, whenever I come across a need of adding a field (column), I grind my teeth knowing I will have to open all the automations, cruise through it to the Action Step referring to the sheet I had added a new field and referesh it and save it. Now this can be done when you are dealing with a few sheets and a few workflows. But as I said, I use 10+ spreadsheets and over 25+ workflows.
Hence, I would like to know if there is a easy way to do the above action.