I need a system that captures posts in a forum, saves that object formatted in a Google sheets and sends it over email. The page must refresh automatically 1x per minute and capture any new posts.
For example, see it attached. I need to capture information in columns such as:
1) Author
2) Timestamp
3) Post title
4) Text content
5) Tags below the text content
Please reach out if you have any questions.
See below an example of a card (post) to be captured:
<div class="cardParent"><div class="card"><div class="card-headermax" style="padding-right: 50px; position: inherit; top: inherit;"><div class="card-header" style="display: flex;"><div class="user-photo" style="padding-top: 3px;"><button style="background: none; border: none; padding: 0px; outline: none;"><img src="
https://tc.tradersclub.com.br/api/v4/users/8hckrjzynjnk8jc6qbn9gr6eey/image" style="width: 40px; height: 40px;"></button></div><div class="contentMember"><div><button style="background: none; border: none; padding: 0px; outline: none;"><p class="title" style="font-size: 17px;">Jose Elias Feres de Almeida </p></button><button class="buttonWithoutStyle"><span style="cursor: pointer; transition: all 0.1s ease 0s; font-weight: 500; font-size: 16px;"> • <span style="color: rgb(69, 103, 233);">Seguir</span></span></button></div><p style="font-size: 13px;">22:03</p></div></div><div style="width: 0px;"><div><div class="select-box--box"><div class="select-box--container" style="height: 35px; width: inherit;"><div class="select-box--selected-item"><button class="tcnews icon-more-options" style="color: rgb(131, 139, 150); font-size: 30px; background: none; border: none; padding: 0px; outline: none;"></button></div><div class="select-box--arrow"></div></div><div class="select-box--items" style="display: none; position: absolute; width: 145px; right: -20px; border-radius: 6px;"><div class="select-box-option-container">Bloquear Usuário</div><div class="select-box-option-container">Denunciar Abuso</div></div></div></div></div></div><div class="card-body" style="cursor: pointer;"><div class="contentIdea"><div style="display: flex;"><img src="
https://tc.tradersclub.com.br/files/anuxce9ta7bouymowuedjq93kw/public?h=2ami9z4-EzkOcQmnZ4GPsKFpkLTJgQ5ShSD1YhY9JNA" style="margin-top: 10px; max-height: 250px; width: auto;"></div><div style="position: relative;"><h2 class="ideaTitleTextPreview" style="position: relative; left: 0px;">Análise da TEGMA (TGMA3) </h2></div><div class="ideaTextPreview"><span>Vasculhando as empresas fora do ibov com bons fundamentos esses dias encontrei a tegma quietinha. Fiz uma análise mais gráfica para facilita...</span></div></div><div class="badges"><div class="badge badge-primary">TGMA3</div><div class="badge badge-primary">IBOV</div><div class="badge badge-positive">Alta</div><div class="badge badge-neutral">AF</div></div></div><div><div class="outline" style="height: 1px; margin-right: 5px;"></div><div class="card-footer"><div style="display: contents;"><div style="display: flex;"><div style="padding-right: 20px; display: flex; align-items: center;"><button class="buttonWithoutStyle" style="border: none; display: flex; align-items: center;"><i class="tcnews icon-bag-money" style="color: rgb(69, 103, 233); font-size: 30px; background: none; border: none; padding: 0px; outline: none;"></i><span style="font-size: 15px; user-select: none;">13</span></button></div><button class="buttonWithoutStyle" style="display: flex; align-items: center;"><i class="tcnews icon-comment" style="color: rgb(69, 103, 233); font-size: 30px;"></i><span style="font-size: 15px; user-select: none;">0</span></button></div><div style="width: 55px;"><div><div class="select-box--box"><div class="select-box--container" style="height: 35px; width: inherit;"><div class="select-box--selected-item"><button class="tcnews icon-advance" style="color: rgb(69, 103, 233); font-size: 30px; background: none; border: none; padding: 0px; outline: none; margin-top: 3px;"></button></div><div class="select-box--arrow"></div></div><div class="select-box--items" style="display: none; position: absolute; width: 77px; border-radius: 6px;"><div class="select-box-option-container">Salvar</div></div></div></div></div></div></div></div></div></div>
Prazo de Entrega: Não estabelecido