2023년 1월 1일부터 하루씩 날짜를 증가시켜가면서 환율정보를 조회한 후 구글 공유문서에 저장하는 방법

Ask in Your Language Korea RPA 개발자를 위한 공간
1

how to store retrieved data from fx rate info site by entering date increasing one day from 2023-01-01
2023년 1월 1일부터 하루씩 날짜를 증가시켜가면서
환율정보사이트에서 날짜를 하나식 입력후 나온 결과값을
구글 공유문서에 조회한 날짜와 조회된 환율 정보를 기록하려면 어떻게 해야하나요?

2

hi @mountie ,
You can follow this steps:
-go to url to get data,
-type each value of day you can use tyep into
-you can get data by data extract
-write data to file
-upload to google sheet
regards,

3

how to get “EACH DATA” from where?

4

I don’t really understand what you mean because it’s in Korean, I translated it using google, hope it’s correct,
Can you describe your requirements specifically?

5

@mountie

Open application/browser to open site
Then navigate to place where you would search

Then use extract datatable or table extraction to extract the data you need into a datatable

Thwn we can write to google sheets using gsuite activities…for these to work create an integration service qnd use gsuite activities

Cheers

6

I found solution.
the question was because of first day newbie

1 Like
7

@mountie

Happy Automation

Cheers