Adding my name to the mix here. Echoing all the previous comments. This is really basic (and valuable) functionality that makes me reconsider even using AirTable. Dashboards was one of the features that sold me on AT initially. But this limitation is...
Actually, just figured it out, at least for me. My Google Sheet was sitting in a Shared Google Drive. And automations don’t support linking to sheets in Shared Drives. I moved the sheet into My Drive and it works fine now.
+1 for me too. I sincerely hope that limitation isn’t intentional. You don’t limit your product’s features to suit a rigid pricing model, you adapt the pricing model for the software (and the best features for it). Otherwise you won’t be in business ...