I’ve been putting together a project to have a freelancer design me a spreadsheet that sorts and pulls hashtags, captions and content and converts them into a csv file to upload to Jarvee. I ran into an issue with the monitoring due to metadata…
So far I have:
- Setup excel spread sheet with lists of hashtags (scraped with Jarvee) seperated by niche and ordered by post quantity.
- Setup formula to add # in front of each tag.
- Organize list of hashtags in 0-50K, 50-100K, 100-300K… ect for macro to pull from.
- Setup macro to choose niche and macros to choose how many tags to pull from each subset.
- organize hashtags to fit in a 73 character space.
- Create a list of captions per niche.
- setup macro to pull a caption from niche and add it to the list of hashtags.
Here comes the issue…
If I want Jarvee to monitor a folder for posts then we have to edit metadata. Instead of editing the metadata by hand I was wondering if anyone has had sucess pyexiftool.
My theory was I could write a script to have excel populate a list of txt files with the above commands into seperate folders and then have pyexiftool populate the metadata from each folder…
What do you guys think?
UPDATE:
I found a script that can be added to adobe bridge that imports an excel spreadsheet to bulk populate metadata to photos and videos. VRA Export Import on github.