I’ve got a publicly shared card that I’m accessing in Google Sheets with its importdata function. What I’d like to do is be able to pass a value to the query from Sheets.
The use case is that we’ve got a team member who needs a client list. The list is generated by the query and it needs another piece of information, in this case the title of a piece of editorial content. Ideally, I’d like my team member to be able to enter the title of the editorial piece in a cell in the spreadsheet, use that entry in the URL construction on which I’m calling importdata, and then get the query result in the sheet.
Is this possible?