Tips
when export BigQuery SQL result to Google Spreadsheet (adunit hyperlink as one field in it), find all hyperlinks don’t work on newly auto created Spreadsheet, cannot click and redirect, an apostrophe ahead of every hyperlink text. With function REGEXREPLACE to replace the head apostrophe, and paste the value, the hyperlink still not work.
)
fortunately, with Spreadsheet API to rewrite the spreadsheet can solve above bug. So here use Google Apps Script to refresh the data.(seeing spreadsheet_tool.gs)
- Menu -> Tools -> Script editor -> paste spreadsheet_tool.gs -> Save -> Run the Script -> Authorize via browser
then you will see Menu -> Custom Tools -> Refresh Current Sheet, choose to click
)
)
)