I used to be a freelance journalist, writing about technology for sites like Digital Trends and How-to Geek, but I found the flexibility of freelancing limited by the hassle of tracking articles for invoicing. To automate this process, I identified my author page on each site and extracted the RSS feed from it, then fed these feeds into a spreadsheet to create a list for invoicing at the end of each month.
To set up this automation, one must first find an author's RSS feed for the website they write for by locating their author page and extracting the RSS feed URL. This can be done using various methods depending on the site, including adding `/feed` to the author page URL or asking someone at the site for the RSS feed URL.
Once the RSS feeds are obtained, they can be connected to a Google spreadsheet using Zapier, allowing for automatic compilation of articles into one place. This setup enables freelancers to spend less time compiling invoices and more time researching and writing their next article. The automation process can be repeated for multiple sites, with options to use various tools such as Trello or Evernote to collect articles in a way that makes it easiest for the individual.