I am trying to create a zap that will automatically take information from a candidate’s profile in Tracker (the candidate tracking software I use) and send it to an activity in Tracker.
The way I figured I could do this is by using Excel. I can automatically send data from Tracker to an Excel spreadsheet by using Link2Excel. I created a report within Tracker that has all the necessary information and linked it to a new Excel spreadsheet. When I click “Refresh Data” in Excel, it updates to the current information.
So the Zap is really from the Excel spreadsheet to Tracker (and thus sending data back to Tracker that was originally in Tracker, but converting into an activity.)
The problem is this: when I update the spreadsheet, it does not add new rows to the bottom. It is updating all the data at once, and arranging them alphabetically.
Is there a way to set up the zap so that it recognizes a new row in excel that is not at the bottom? Is there another step I can add or a different way of doing this to fix the problem?
Best answer by Troy TessaloneView original