I have been spending hours to list my pubs for my CV or co-authors for a grant proposal. But now, we can automate this process with R package scholar (see R documentation for general guidance). With some stringr and dplyr functions, it’s pretty easy to export a table of pubs/coauthors via Rmarkdown (if you are unfamiliar with Rmarkdown, see Rmarkdown cookbook). A procedure would be:

  1. extract your pub list
  2. transform with stringr & dplyr functions
  3. export with Rmarkdown (or simply write_csv())

Publication list

Quick example for a pub list:

## GET YOUR PUB LIST

# library -----------------------------------------------------------------

rm(list = ls())
pacman::p_load(tidyverse,
               scholar)

# data --------------------------------------------------------------------

## your google id - can be found in the link bar of your google scholar page
sid <- "H9OuCKsAAAAJ"

## get publication list
pubs <- get_publications(sid) %>% 
  as_tibble()

## html output - needs adjusments for word/pdf outputs
pubs %>% 
  kableExtra::kbl() %>% 
  kableExtra::kable_paper() %>% 
  kableExtra::scroll_box(height = "300px")
title author journal number cites year cid pubid
Metapopulation stability in branching river networks A Terui, N Ishiyama, H Urabe, S Ono, JC Finlay, F Nakamura Proceedings of the National Academy of Sciences 115 (26), E5963-E5969 54 2018 3464610354397260439 mlAyqtXpCwEC
Asymmetric dispersal structures a riverine metapopulation of the freshwater pearl mussel Margaritifera laevis A Terui, Y Miyazaki, A Yoshioka, K Kaifu, SS Matsuzaki, I Washitani Ecology and evolution 4 (15), 3004-3014 35 2014 13027117053567911900 Tyk-4Ss8FVUC
Dispersal of larvae of Margaritifera laevis by its host fish A Terui, Y Miyazaki, A Yoshioka, T Kadoya, F Jopp, I Washitani Freshwater Science 33 (1), 112-123 28 2014 10199785609446090856 2osOgNQ5qMEC
Parasite infection induces size-dependent host dispersal: consequences for parasite persistence A Terui, K Ooue, H Urabe, F Nakamura Proceedings of the Royal Society B: Biological Sciences 284 (1866), 20171491 20 2017 14498315894104540030 XvxMoLDsR5gC
A delayed effect of the aquatic parasite Margaritifera laevis on the growth of the salmonid host fish Oncorhynchus masou masou K Ooue, A Terui, H Urabe, F Nakamura Limnology 18 (3), 345-351 18 2017 12915293467188528888 NXb4pA-qfm4C
Influence of connectivity, habitat quality and invasive species on egg and larval distributions and local abundance of crucian carp in Japanese agricultural landscapes SM Shin-ichiro, A Terui, K Kodama, M Tada, T Yoshida, I Washitani Biological Conservation 144 (8), 2081-2087 18 2011 2733290986498968443 u5HHmVD_uO8C
Illustrated checklist of fishes from the Shubuto River System, southwestern Hokkaido, Japan Y Miyazaki, A Terui, H Senou, I Washitani Check List 9 (1), 63-72 17 2013 15896098794152814267 IjCSPb-OGe4C
RivFishTIME: A global database of fish time‐series to study global change ecology in riverine systems L Comte, J Carvajal‐Quintero, PA Tedesco, X Giam, U Brose, T Erős, … Global Ecology and Biogeography 30 (1), 38-50 15 2021 7210329059921443522 TNEldfgDb5MC
Stream resource gradients drive consumption rates of supplemental prey in the adjacent riparian zone A Terui, JN Negishi, N Watanabe, F Nakamura Ecosystems 21 (4), 772-781 15 2018 11039898352231311044 4hFrxpcac9AC
A “parasite-tag” approach reveals long-distance dispersal of the riverine mussel Margaritifera laevis by its host fish A Terui, Y Miyazaki Hydrobiologia 760 (1), 189-196 15 2015 15345645246993949702 L7CI7m0gUJcC
Factors affecting the local occurrence of the near-threatened bitterling (Tanakia lanceolata) in agricultural canal networks: strong attachment to its potential host mussels A Terui, SS Matsuzaki, K Kodama, M Tada, I Washitani Hydrobiologia 675 (1), 19-28 15 2011 4495101694570705096 d1gkVwhDpl0C
How much abandoned farmland is required to harbor comparable species richness and abundance of bird communities in wetland? Hierarchical community model suggests the importance … M Hanioka, Y Yamaura, S Yamanaka, M Senzaki, K Kawamura, A Terui, … Biodiversity and conservation 27 (8), 1831-1848 14 2018 18295977239229834349 6ZxmRoH8BuwC
High resilience of aquatic community to a 100-year flood in a gravel-bed river JN Negishi, A Terui, B Nessa, K Miura, T Oiso, K Sumitomo, T Kyuka, … Landscape and Ecological Engineering 15 (2), 143-154 13 2019 16668563894363926134 pUxgyZctzPYC
Predicting the ecological impacts of large‐dam removals on a river network based on habitat‐network structure and flow regimes N Ishiyama, M Ryo, T Kataoka, S Nagayama, M Sueyoshi, A Terui, T Mori, … Conservation Biology 32 (6), 1403-1413 12 2018 11677432363381237923 2VqYfGB8ITEC
Detection of vegetation trends in highly variable environments after grazing exclusion in Mongolia K Kakinuma, A Terui, T Sasaki, A Koyama, U Jamsran, T Okuro, … Journal of Vegetation Science 28 (5), 965-974 11 2017 13117287021548228709 umqufdRvDiIC
Ecological evaluation of the conservation of fish fauna in the Shubuto River system, southwestern Hokkaido. Y Miyazaki, A Terui, S Kubo, N Hatai, K Takahashi, H Saitoh, I Washitani Japanese Journal of Conservation Ecology 16 (2), 213-219 10 2011 6408254242448663837 9yKSN-GCB0IC
Population status and factors affecting local density of endangered Japanese freshwater pearl mussel, Margaritifera laevis, in Shubuto River basin, Hokkaido. A Terui, Y Miyazaki, SS Matsuzaki, I Washitani Japanese Journal of Conservation Ecology 16 (2), 149-157 10 2011 6889015042940339944 u-x6o8ySG0sC
Temporal dynamics of fluvial fish community caused by marine amphidromous species in the Shubuto River, southwestern Hokkaido, Japan Y Miyazaki, A Terui Ichthyological research 63 (1), 173-179 9 2016 13804860059813398034 hMsQuOkrut0C
Long-term declines in common breeding seabirds in Japan M Senzaki, A Terui, N Tomita, F Sato, Y Fukuda, Y Kataoka, Y Watanuki Bird Conservation International 30 (3), 434-446 8 2020 7164719196565091022 C5mqfHIFIucC
Emergent dual scaling of riverine biodiversity A Terui, S Kim, CL Dolph, T Kadoya, Y Miyazaki Proceedings of the National Academy of Sciences 118 (47), e2105574118 7 2021 16440814085696101323 JhbybO29vGQC
Species-specific use of allochthonous resources by ground beetles (Carabidae) at a river–land interface A Terui, T Akasaka, JN Negishi, F Uemura, F Nakamura Ecological research 32 (1), 27-35 6 2017 2664542394393271399 FAceZFleit8C
Difference in habitat use between the two related goby species of Gymnogobius opperiens and Gymnogobius urotaenia: a case study in the Shubuto River System, Hokkaido, Japan Y Miyazaki, A Terui Ichthyological research 63 (3), 317-323 6 2016 7746193241917481679 kh2fBNsKQNwC
Restoration of the shifting mosaic of floodplain forests under a flow regime altered by a dam F Nakamura, Y Watanabe, J Negishi, T Akasaka, Y Yabuhara, A Terui, … Ecological Engineering 157, 105974 5 2020 8593829870272509529 _TjUWtciUekC
Combined effects of immigration potential and habitat quality on diadromous fishes A Terui, Y Miyazaki Limnology 18 (1), 121-129 5 2017 13437630171012378566 9pM33mqn1YgC
Three ecological factors influencing riverine fish diversity in the Shubuto River system, Japan: habitat capacity, habitat heterogeneity and immigration A Terui, Y Miyazaki Limnology 17 (2), 143-149 5 2016 9841985143584598706 bz8QjSJIRt4C
A cryptic Allee effect: spatial contexts mask an existing fitness–density relationship A Terui, Y Miyazaki, A Yoshioka, SS Matsuzaki Royal Society Open Science 2 (6), 150034 5 2015 5955060897611196204 ILKRHgRFtOwC
Non‐random dispersal in sympatric stream fishes: Influences of natural disturbance and body size A Terui, S Kim, KC Pregler, Y Kanno Freshwater Biology 66 (10), 1865-1875 3 2021 14028339771303816850 CKf5m1HYVjMC
Quantifying cryptic function loss during community disassembly A Terui, JC Finlay, AT Hansen, JL Kozarek Journal of Applied Ecology 56 (12), 2710-2722 3 2019 3131442279887291893 eLRq4zTgah0C
Spatial disturbance synchrony alters the association of food chain length and ecosystem size A Terui, S Nishijima Ecological Research 34 (6), 864-871 3 2019 8856763272689699430 XUAslYVNQLQC
Fish species composition of temporary small lentic habitats in the floodplains of the Shubuto River System: factors affecting species richness and suggestions for conservation … Y Miyazaki, A Terui, A Yoshioka, K Kaifu, I Washitani Japanese Journal of Conservation Ecology 18 (1), 55-68 3 2013 10265235201855021860 DUooU5lO8OsC
Changes in the strictly freshwater fish fauna around Lake Mikata, Fukui Prefecture, Japan, inferred from monitoring data and ecological trait information. SS Matsuzaki, K Kodama, A Terui, H Takeshima, T Sato, O Tominaga, … Japanese Journal of Conservation Ecology 16 (2), 205-212 3 2011 16784091824624973592 zYLM7Y9cAGgC
Modeling dispersal using capture–recapture data: A comparison of dispersal models A Terui Ecological Research 35 (5), 686-699 2 2020 17351364749502466945 t9Ks5LMjN0QC
Spatiotemporal dimensions of community assembly N Shinohara, R Nakadai, Y Suzuki, A Terui Population Ecology 1 2022 12625320567245151573 xm1hsP5ya-EC
The Relative Effects of Biotic and Abiotic Factors on the Recruitment of Freshwater Mussels (Margaritifera laevis) K Kawajiri, N Ishiyama, K Miura, A Terui, M Sueyoshi, F Nakamura Water 13 (9), 1289 1 2021 18289670563885527091 gL9scSG3K_gC
Impact of alien species on the distribution of native submerged macrophytes in small rivers and agricultural canals around Lake Mikata. S Kubo, A Terui, J Nishihiro, I Washitani Japanese Journal of Conservation Ecology 17 (2), 165-173 1 2012 14004150295229240402 qjMakFHDy7sC
Toward the comprehensive understanding of food chain length S Shibasaki, A Terui EcoEvoRxiv 0 2022 NA UY3hNwcQ290C
Metapopulation‐level associations in positively interacting stream fishes S Kim, CL Dolph, A Terui Ecography 2022 (3), e06080 0 2022 NA yaBp1wUtcLsC
Mathematical characterization of fractal river networks A Terui bioRxiv 0 2022 NA vkz5F8TaVKkC
Intentional stocking undermines ecological stability A Terui, H Urabe, M Senzaki, B Nishizawa bioRxiv 0 2022 NA SEKBqlyTJecC

Coauthor list

Quick example for a co-author list:

## get coauthor list
coauthor <- pubs %>% 
  rowwise() %>%
  summarise(year = year,
            authors = get_complete_authors(sid,
                                           pubid,
                                           initials = FALSE))
## one author per row
df_coauthor <- coauthor %>% 
  rowwise() %>% 
  summarize(year = year,
            author = str_split(authors,
                               pattern = ",\\s") %>% 
              flatten_chr()) %>% 
  filter(year >= 2019,
         author != "Akira Terui") %>% 
  distinct(author) %>% 
  separate(author,
           into = c("a", "b", "last"),
           sep = "\\s",
           fill = "left") %>% 
  mutate(first = ifelse(is.na(a), b, paste(a, b)),
         full = paste(last, first, sep = ", ")) %>% 
  select(-a, -b) %>% 
  arrange(last)

## html output - needs adjusments for word/pdf outputs
df_coauthor %>% 
  kableExtra::kbl() %>% 
  kableExtra::kable_paper() %>% 
  kableExtra::scroll_box(height = "300px")
last first full
Akasaka Takumi Akasaka, Takumi
Becker Fernando G Becker, Fernando G
Brose Ulrich Brose, Ulrich
Carvajal‐Quintero Juan Carvajal‐Quintero, Juan
Casatti Lilian Casatti, Lilian
Castaldelli Giuseppe Castaldelli, Giuseppe
Comte Lise Comte, Lise
Dala‐Corte Renato B Dala‐Corte, Renato B
Davenport Stephen R Davenport, Stephen R
Dolph Christine L Dolph, Christine L
Erős Tibor Erős, Tibor
Filipe Ana F Filipe, Ana F
Finlay Jacques C Finlay, Jacques C
Fortin Marie‐Josée Fortin, Marie‐Josée
Franssen Nathan R Franssen, Nathan R
Fukuda Yoshihiro Fukuda, Yoshihiro
García‐Berthou Emili García‐Berthou, Emili
Gavioli Anna Gavioli, Anna
Giam Xingli Giam, Xingli
Gido Keith B Gido, Keith B
Hansen Amy T Hansen, Amy T
Irving Katie Irving, Katie
Ishiyama Nobuo Ishiyama, Nobuo
Jacquet Claire Jacquet, Claire
Jimenez‐Segura Luz Jimenez‐Segura, Luz
Kadoya Taku Kadoya, Taku
Kanno Yoichiro Kanno, Yoichiro
Kataoka Yoshihiro Kataoka, Yoshihiro
Kawajiri Keita Kawajiri, Keita
Kim Seoghyun Kim, Seoghyun
Konno Miwa Konno, Miwa
Kozarek Jessica L Kozarek, Jessica L
Kyuka Tomoko Kyuka, Tomoko
Larsen Stefano Larsen, Stefano
Leitão Rafael P Leitão, Rafael P
McLarney Bill McLarney, Bill
Meador Jason Meador, Jason
Milardi Marco Milardi, Marco
Miura Kazuki Miura, Kazuki
Miyazaki Yusuke Miyazaki, Yusuke
Moffatt David B Moffatt, David B
Nakadai Ryosuke Nakadai, Ryosuke
Nakamura Futoshi Nakamura, Futoshi
Negishi Junjiro N Negishi, Junjiro N
Negishi Junjiro Negishi, Junjiro
Nessa Badrun Nessa, Badrun
Nishijima Shota Nishijima, Shota
Nishizawa Bungo Nishizawa, Bungo
Occhi Thiago VT Occhi, Thiago VT
Oiso Takeaki Oiso, Takeaki
Olden Julian D Olden, Julian D
Pompeu Paulo S Pompeu, Paulo S
Pregler Kasey C Pregler, Kasey C
Propst David L Propst, David L
Pyron Mark Pyron, Mark
Ruhi Albert Ruhi, Albert
Salvador Gilberto N Salvador, Gilberto N
Sato Fumio Sato, Fumio
Senzaki Masayuki Senzaki, Masayuki
Sharma Sapna Sharma, Sapna
Shibasaki Shota Shibasaki, Shota
Shinohara Naoto Shinohara, Naoto
Stefferud Jerome A Stefferud, Jerome A
Sueyoshi Masanao Sueyoshi, Masanao
Sumitomo Keizo Sumitomo, Keizo
Sutela Tapio Sutela, Tapio
Suzuki Yuka Suzuki, Yuka
Taylor Christopher Taylor, Christopher
Tedesco Pablo A Tedesco, Pablo A
Tomita Naoki Tomita, Naoki
Urabe Hirokazu Urabe, Hirokazu
Vehanen Teppo Vehanen, Teppo
Vitule Jean RS Vitule, Jean RS
Watanabe Yasuharu Watanabe, Yasuharu
Watanuki Yutaka Watanuki, Yutaka
Yabuhara Yuki Yabuhara, Yuki
Yamanaka Satoshi Yamanaka, Satoshi
Yonemoto Mitsuaki Yonemoto, Mitsuaki
Zeni Jaquelini O Zeni, Jaquelini O

Outputs can be saved as .pdf, .html, or .docx via Rmarkdown.