All posts

How to Use ChatGPT With Google Drive to Create a Weekly Project Report

Automate weekly project reports by connecting ChatGPT to Google Drive.

8 min read
On this page

A weekly project report should tell you what moved, what’s stuck, and what needs a decision. The slow part is usually collecting that information from a tracker, meeting notes, and last week’s update.

ChatGPT can use Google Drive as the source for that first draft. Connect Drive, point it at the right files, and give it a reporting period and a consistent format. You’ll use ChatGPT Work on the web, with three source files and a report you review before sharing.

ChatGPT processes Google Drive files for a project report, displaying a calendar and bar graph on a document.

Step 1: Connect Google Drive

Open ChatGPT in your browser and choose Work. This is the mode for a task that needs several sources and a finished document. The Google Drive plugin supplies access to connected Drive files, including Google Docs and Sheets.

  1. Open Customize, then Plugins, in the left sidebar.
    ChatGPT Settings page showing the Plugins option selected
  2. Search for Google Drive, open its details, and select the plus button to install it.
    Plugins management screen in Google Drive customization settings
  3. Then select Add:

Google Drive plugin listing in ChatGPT, offering access to Drive, Docs, Sheets or Slides.

  1. Connect the Google account that can open your project files when prompted. Review the requested permissions.
    Google plugins installation options displayed; Google Drive is selected.
  2. (Once Installed) Start a new chat. Type @ and select Google Drive from the plugin suggestions.

@google Drive option selected for ChatGPT plugin connection.

Type @ and choose Google Drive to direct the request to the connected plugin.

Check that Work and Google Drive are enabled for your plan and workspace. ChatGPT Plus is US$20 per month at the time of writing; Work uses your plan’s allowance, and recurring runs also consume usage. Availability and workspace restrictions can differ.

Before moving on, ask ChatGPT to read one exact project-file link and return its title. A successful connection should retrieve the file, rather than offer a general summary of what a project tracker might contain.

Step 2: Choose the files for this week

Start with a small reporting set. For a website refresh, these three files cover progress, explanations, and the comparison with last week.

FileWhat it contributes
Project TrackerTask IDs, status, owner roles, due dates, and completion dates. Name the relevant Sheets tab and columns.
Weekly NotesDecisions, blockers, and explanations dated within the reporting period.
Previous Weekly ReportThe approved baseline for identifying what changed.

Google Drive folder list displaying project files, including Meeting Notes, Process and Procedures, and Q4 Forecast.

An example Drive folder groups project material. Name the exact documents the report should use.

Paste each exact file link into the chat. You can keep related material in a ChatGPT Project, but still name the files the report should use. A shared folder alone doesn’t tell ChatGPT which tracker is authoritative.

Prompt

Use @Google Drive to check these reporting sources:

Tracker: [paste file link], tab [tab name], columns [relevant columns]

Weekly notes: [paste file link]

Previous report: [paste file link]

List the files you can read, the reporting dates they cover, and any missing or conflicting information. Don’t write the report yet. Keep the response anonymous: use role labels, omit personal and organisation details, and add no signature.

Set an exact cutoff, such as Friday at 17:00 UTC. Check dates inside the records: a file edited on Friday can still contain a decision from three months ago. If the tracker overwrites old statuses, keep dated snapshots or a change log so next week’s comparison has a reliable baseline.

Step 3: Draft the weekly project report

Once the source check passes, give ChatGPT the report’s shape. Ask for changes during the week as well as the current position; otherwise, completed work can reappear as a fresh achievement every Friday.

Google Drive request to find a Maple Lane Books financial report and summarize Q4 projections.

An example Drive request identifies a particular report and the information to extract.

Prompt

Create a weekly project report for [project] covering [start date and time] through [end date and time], in [time zone]. Write for a project lead who needs to spot delays and make decisions.

Use only the three Google Drive files checked above. Read the sources again and compare them with the previous report. For changes, use events dated within the reporting period. For current status, use the cutoff snapshot. Flag any source updated after the cutoff if its earlier state can’t be recovered.

Keep the report under 500 words with these sections:

1. Overall status: on track, at risk, blocked, or unconfirmed, with a brief reason.

2. Completed this week: newly finished work, supported by completion dates.

3. Progress and changes: milestones, scope changes, and relevant counts, with their basis.

4. Blockers and decisions needed: impact, owner role, and next decision date.

5. Next week: action, owner role, and due date.

6. Missing or conflicting information.

Link material claims to the source file and identify the relevant tab, task ID, or dated note. Separate confirmed facts from assumptions. Don’t invent dates, commitments, completion percentages, or owners. Keep older unresolved blockers visible.

Use anonymous role labels only. Omit names, organisations, contact details, account information, and signatures. Don’t use profile details or remembered personal context.

Return a draft in this chat. Don’t change the source files, send the report, or publish it.

Be precise about numbers. If 8 of 12 tasks are complete, that’s a task count. It doesn’t establish that 67% of the total effort is finished, because those tasks may differ in size. Ask for a percentage only when the tracker defines how to calculate it.

Step 4: Check the draft and save it in Drive

Read the draft alongside its source files. Start with the claims that could change someone’s next action.

  1. Open the evidence for completed work, changed deadlines, and decisions. A plan to finish isn’t a recorded completion.
  2. Check totals and reporting dates. Separate this week’s additions from work already reported.
  3. Resolve contradictory notes. An overdue review should stay unresolved until an authoritative update confirms it is complete.

Google Drive prompt asking to allow ChatGPT to use Google Drive Batch Update Document tool.

A document-editing request can show the exact Drive tool and ask for approval before making a change.

If a deadline conflicts, use a targeted follow-up: “The tracker says 12 November; the dated note says 16 November. Show both and mark the deadline unconfirmed. Keep the report anonymous and add no signature.”

After checking the content, ask: “Turn the approved draft into an editable DOCX. Keep the headings and source links, preserve anonymity, and add no signature.” Then save it to Drive:

  1. Download the DOCX from ChatGPT.
  2. In Google Drive, choose New, then File upload, and select the document.
  3. Open the uploaded file with Google Docs. If you want a native Google document, use File, then Save as Google Docs.

Open the saved version and check the dates, headings, and links. If your connected Drive tools support creating documents directly, you can ask for that instead; confirm the destination and return document link. A draft displayed in chat hasn’t necessarily been saved in Drive.

Step 5: Repeat the report every week

Get one manual report right before scheduling it. On supported ChatGPT web accounts, scheduled tasks can use the connected tools and plugins available to the chat. Keep the source links and reporting rules in the saved instructions.

Scheduled tasks list with weekly business review option selected

Open Scheduled to inspect recurring tasks, including a weekly business review.

Prompt

Schedule this reporting workflow for every Friday at 17:30 UTC in this chat. Each run should cover that Monday at 00:00 through Friday at 17:00 UTC.

Use the exact three Drive source links already checked and the approved report structure. Read fresh sources each time. Use the latest approved previous report as the comparison, and flag it if no current baseline is available. Keep all anonymity rules and source links.

If a file is inaccessible or too stale to support the report, identify the gap rather than filling it in. Return a draft for review. Don’t send, publish, overwrite source files, or change sharing permissions.

Open Scheduled and verify the day, time zone, task status, and instructions. Inspect the first few runs. Update the previous-report link after approving each report, or give the task a precise naming rule for finding the latest approved version.

ChatGPT permissions settings: Always ask, allow read-only tools, allow low-risk tools, allow all tools.

If scheduling isn’t available in your workspace, reuse the reporting chat manually each Friday. Once the format is stable, you can also save the instructions as a reusable skill. A recurring task still needs current source records.

Conclusion

A useful weekly report makes the next decision easier. Keep the draft short enough to review, retain evidence for changed deadlines and completed work, and finish by opening the saved file. That final check matters more than how polished the answer looks in chat.

Frequently Asked Questions

Can ChatGPT read every file in Google Drive?

It can access only files allowed by the connected account, enabled tools, and workspace restrictions.

Why can’t ChatGPT open a project file?

Check the connected Google account, file permissions, exact link, and workspace restrictions. Reconnect if authentication has expired.

Can the weekly report run automatically?

Supported web accounts can schedule recurring runs using connected tools. Test the prompt first and check the schedule.

Does ChatGPT automatically save the report in Drive?

Confirm that supported write tools saved it, or download the DOCX and upload it yourself

Last updated: Nov 16, 2026

Build your teammate team in 30 seconds.

Build teammate teams that work along with your team. Free to start, no card required.