![]() Sheets will periodically refresh the results using the CSV link, so if we have a scheduled query set up in PopSQL this will ensure Sheets is always pulling in the latest results. You can now work with your query data inside of Google Sheets. Press enter and your query results should appear: Click into a cell and enter the formula: = IMPORTDATA("") In Google Sheets, you can now use the IMPORTDATA function with the CSV link to pull in our query results. You may need to configure your account settings to allow public sharing if these options are not available. Note that we need to provide public access to your query results in order for Google to be able to fetch them on your behalf, so you must set your query permission to "Public" and check the "Include results" box. You can find the CSV link for your query in the share modal: ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |