I hope that works out for you!
Note that I haven't tried the solution of using Elasticsearch input plugin myself. I'll try it out hopefully soon when I have some time. I did some research though, and it looks like someone was able to get it to work and index their aggregation buckets as documents in a new index: Aggregation Query possible input ES plugin