I have a zap running to parse out an emailed application into a new row in google sheets. I am trying to figure out the best practice for enabling manipulation of the information without messing up the process. Right now I have the data import to another sheet in the workbook and the team edits the additional columns which track status for each row. However this can lead to errors when a row changes in source or we want to archive information as those core functions of the rows are still attached to the import sheet. I want to be able to connect the manual to the imported data and keep it set as a row so things don’t get messed up.
Best answer by onetail
I have explored Airtable however we are a non-profit and have multiple volunteers who need to access and the free account I don’t think will meet the need.