If you set your Google Sheets as a trigger, you may encounter a situation where the recipe picks up the row before you are done populating all the columns. To prevent incomplete data from being used for for population, you may want to set up your recipe like this one.
Step 1 is a conditional action, set up such that if the last column is "not present", or does not contain any data, the recipe will wait (Step 2) for a set amount of time (you can use a 5 minute wait). This amount of time should depend on how much time is expected to complete each row by manual entry.
Step 3 will then run a search in the same sheet from the trigger, using the first column's data. This action will allow you to go back and use the completed data instead of the trigger data. As such, all following steps that require pills from the row should be acquired from this step, and not from the trigger output. Do note that this step will only work for a search query with the data being a unique identifier. If the search returns multiple results, the search may not return the row you actually want processed.
This is how it should look:
Once these 3 steps are set up, you can add additional steps that require the data from these columns for mapping to other applications!