{"id":1007,"date":"2021-08-03T18:15:41","date_gmt":"2021-08-03T17:15:41","guid":{"rendered":"https:\/\/www.filippoboninsegna.com\/?p=1007"},"modified":"2022-02-19T16:10:42","modified_gmt":"2022-02-19T15:10:42","slug":"august-3-2021","status":"publish","type":"post","link":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/","title":{"rendered":"2021-08-03"},"content":{"rendered":"\n

Blinkist book summaries<\/a><\/p>\n\n\n\n

\n\n\n\n

GTD<\/a> (post draft)<\/p>\n\n\n\n

\n\n\n\n

Being Anonymous Online<\/a> (post draft) <\/p>\n\n\n\n

\n\n\n\n

How To Sell A Website<\/a> (post draft) <\/p>\n\n\n\n

\n\n\n\n

How To Protect Your Privacy Online<\/a> (post draft) <\/p>\n\n\n\n

\n\n\n\n

Updated the Content Creation<\/a> post (added rule #1 about “journaling”, rule #3 about “tweeting” and rule #4 about “quotes”).<\/p>\n\n\n\n

\n\n\n\n

Content Ideas<\/a> (post draft) <\/p>\n\n\n\n

\n\n\n\n

“How to integrate Pocket and WordPress.” Pocket to wordpress<\/a>.<\/p>\n\n\n\n

I decided to use Google Tasks for my to-do list (it’s integrated in Gmail and it’s handy to use on my phone), but, when on my pc, I would like to be able to read the list on a Google doc or sheet. So I looked for a solution. <\/p>\n\n\n\n

I found this article<\/a> on Medium. But it doesn’t help me much. Yes, I like being able to open Tasks next to a Google sheet, but I’d like my tasks to sync to a sheet<\/strong>, so that I can then sort them and whatnot. <\/strong>I saved<\/a> that article to go back to, as it gives some useful tips on how to leverage Tasks.<\/p>\n\n\n\n

I found this Zapier workflow<\/a>. But, I’d like something quicker to set up, plus, I think I might not need syncing capabilities, after all. I find benefit in copying and pasting a few tasks each day from Tasks to Google sheets, as that alone will keep me more accountable.<\/p>\n\n\n\n

I then found this information: Export your data from Google Tasks<\/a> and How to download your Google data<\/a>. I decided to export my huge Tasks list and import it into Sheets. I intend to regularly add all the new tasks by copy-pasting them from Tasks (on my pc) by opening Tasks beside (“side-by-side<\/em>“) the Google Sheet.<\/p>\n\n\n\n

To download your Google data, go to Google Takeout<\/a> and select which data you want to export. I downloaded my Tasks data. It’s a JSON file by default. So I converted it to csv here<\/a>. I uploaded the csv file to Sheets and then had to spend some time cleaning it up, as it comes full with meta data that I don’t need.<\/p>\n","protected":false},"excerpt":{"rendered":"

Blinkist book summaries GTD (post draft) Being Anonymous Online (post draft) How To Sell A Website (post draft) How To Protect Your Privacy Online (post draft) Updated the Content Creation post (added rule #1 about “journaling”, rule #3 about “tweeting” and rule #4 about “quotes”). Content Ideas (post draft) “How to integrate Pocket and WordPress.” […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[60],"tags":[243,244],"yoast_head":"\n2021-08-03 - Filippo Boninsegna<\/title>\n<meta name=\"description\" content=\"GTD, being anonymous online, how to sell a website, how to protect your privacy online, content creation rules, Google Tasks in Google Sheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2021-08-03 - Filippo Boninsegna\" \/>\n<meta property=\"og:description\" content=\"GTD, being anonymous online, how to sell a website, how to protect your privacy online, content creation rules, Google Tasks in Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\" \/>\n<meta property=\"og:site_name\" content=\"Filippo Boninsegna\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-03T17:15:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-19T15:10:42+00:00\" \/>\n<meta name=\"author\" content=\"Filippo Boninsegna\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fboninsegna\" \/>\n<meta name=\"twitter:site\" content=\"@fboninsegna\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Filippo Boninsegna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\"},\"author\":{\"name\":\"Filippo Boninsegna\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\"},\"headline\":\"2021-08-03\",\"datePublished\":\"2021-08-03T17:15:41+00:00\",\"dateModified\":\"2022-02-19T15:10:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\"},\"wordCount\":337,\"publisher\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\"},\"keywords\":[\"google tasks\",\"google tools\"],\"articleSection\":[\"Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\",\"url\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\",\"name\":\"2021-08-03 - Filippo Boninsegna\",\"isPartOf\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#website\"},\"datePublished\":\"2021-08-03T17:15:41+00:00\",\"dateModified\":\"2022-02-19T15:10:42+00:00\",\"description\":\"GTD, being anonymous online, how to sell a website, how to protect your privacy online, content creation rules, Google Tasks in Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/august-3-2021\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.filippoboninsegna.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2021-08-03\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/#website\",\"url\":\"https:\/\/www.filippoboninsegna.com\/\",\"name\":\"Filippo Boninsegna\",\"description\":\"Investing, content marketing, automation\",\"publisher\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.filippoboninsegna.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\",\"name\":\"Filippo Boninsegna\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png\",\"contentUrl\":\"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png\",\"width\":512,\"height\":512,\"caption\":\"Filippo Boninsegna\"},\"logo\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2021-08-03 - Filippo Boninsegna","description":"GTD, being anonymous online, how to sell a website, how to protect your privacy online, content creation rules, Google Tasks in Google Sheets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/","og_locale":"en_US","og_type":"article","og_title":"2021-08-03 - Filippo Boninsegna","og_description":"GTD, being anonymous online, how to sell a website, how to protect your privacy online, content creation rules, Google Tasks in Google Sheets.","og_url":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/","og_site_name":"Filippo Boninsegna","article_published_time":"2021-08-03T17:15:41+00:00","article_modified_time":"2022-02-19T15:10:42+00:00","author":"Filippo Boninsegna","twitter_card":"summary_large_image","twitter_creator":"@fboninsegna","twitter_site":"@fboninsegna","twitter_misc":{"Written by":"Filippo Boninsegna","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/#article","isPartOf":{"@id":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/"},"author":{"name":"Filippo Boninsegna","@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6"},"headline":"2021-08-03","datePublished":"2021-08-03T17:15:41+00:00","dateModified":"2022-02-19T15:10:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/"},"wordCount":337,"publisher":{"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6"},"keywords":["google tasks","google tools"],"articleSection":["Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/","url":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/","name":"2021-08-03 - Filippo Boninsegna","isPartOf":{"@id":"https:\/\/www.filippoboninsegna.com\/#website"},"datePublished":"2021-08-03T17:15:41+00:00","dateModified":"2022-02-19T15:10:42+00:00","description":"GTD, being anonymous online, how to sell a website, how to protect your privacy online, content creation rules, Google Tasks in Google Sheets.","breadcrumb":{"@id":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.filippoboninsegna.com\/august-3-2021\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.filippoboninsegna.com\/august-3-2021\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.filippoboninsegna.com\/"},{"@type":"ListItem","position":2,"name":"2021-08-03"}]},{"@type":"WebSite","@id":"https:\/\/www.filippoboninsegna.com\/#website","url":"https:\/\/www.filippoboninsegna.com\/","name":"Filippo Boninsegna","description":"Investing, content marketing, automation","publisher":{"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.filippoboninsegna.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6","name":"Filippo Boninsegna","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/","url":"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png","contentUrl":"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png","width":512,"height":512,"caption":"Filippo Boninsegna"},"logo":{"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts\/1007"}],"collection":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/comments?post=1007"}],"version-history":[{"count":1,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts\/1007\/revisions"}],"predecessor-version":[{"id":1534,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts\/1007\/revisions\/1534"}],"wp:attachment":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/media?parent=1007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/categories?post=1007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/tags?post=1007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}