# How to autocomplete Wordpress site via Google Sheets and Make 20,000+ pages?

**URL:** https://community.make.com/t/how-to-autocomplete-wordpress-site-via-google-sheets-and-make-20-000-pages/57972
**Category:** Questions
**Tags:** wordpress, google-sheets
**Created:** [October 15, 2024, 9:05pm UTC](https://community.make.com/t/how-to-autocomplete-wordpress-site-via-google-sheets-and-make-20-000-pages/57972 "2024-10-15T21:05:13Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Alex\_Art](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@Alex\_Art](https://community.make.com/u/Alex_Art)
#### Post date: [October 15, 2024, 9:05pm UTC](https://community.make.com/t/how-to-autocomplete-wordpress-site-via-google-sheets-and-make-20-000-pages/57972/1 "2024-10-15T21:05:13Z")

</div>

Hi, I have a Wordpress website and have 20,000+ pages created on it of this type: Title and Shortcode. I already have a Google Sheets table ready with content for these pages. And my task is as follows:

1. Upload all the slugs from a particular section of the site to Google Sheets
2. All slugs should be uploaded in accordance with the created content in Google Sheets (the page name on the site corresponds to the cell with the name in Google Sheets).
3. The updated Google Sheets table should be uploaded via Make to the already created pages as a simple table (about 10 values). That is, there will be about 20,000 new records in Google Sheets and they should be sent to the already created pages of the Wordpress site.

Can you please tell me how to realize this with Make?

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [October 16, 2024, 1:21am UTC](https://community.make.com/t/how-to-autocomplete-wordpress-site-via-google-sheets-and-make-20-000-pages/57972/2 "2024-10-16T01:21:31Z")

</div>

Welcome to the Make community!

I would suggest completing the **Make Academy** before jumping into building a complete scenario. If you need **specific assistance** when you are **building a scenario** it’s easier to help you then. Otherwise, you can also **hire a professional** by posting a request in the #Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

### Getting Started

- [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual”
- [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified

### Help Centre Basics

- [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output)
- **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting)
- [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file
- [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks

### Articles & Videos

- [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube
- [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist
- [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make
- [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want
- [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [January 14, 2025, 2:25am UTC](https://community.make.com/t/how-to-autocomplete-wordpress-site-via-google-sheets-and-make-20-000-pages/57972/3 "2025-01-14T02:25:30Z")

</div>


